Posted On: Aug 27, 2021
Amazon Aurora with PostgreSQL compatibility now supports major version 13. PostgreSQL 13 includes improved functionality and performance from new features and performance from new features and enhancements such as de-duplication of B-tree index entries, improved performance for queries that use partitioned tables, incremental sorting to accelerate data sorts, parallel processing of indexes with the VACUUM command, more ways to monitor activity within a PostgreSQL database, new security capabilities, and more. This release also adds support for bool_plperl, which simplifies writing Perl procedures.
With PostgreSQL 13 on Amazon Aurora with PostgreSQL compatibility you can create time series data tables with improved data ingestion rates of several hundred thousands of metrics per second for use cases such as storing DevOps metrics or tracking business metrics (e.g., daily sales).
To use the new version, create a new Amazon Aurora PostgreSQL database instance with just a few clicks in the Amazon RDS Management Console. You can also use the in-place upgrade functionality to minimize downtime during an upgrade. Please review the Aurora documentation to learn more. PostgreSQL 13 is available in all regions supported by Amazon Aurora PostgreSQL, including in Amazon Web Services China (Beijing) region, operated by Sinnet, and Amazon Web Services China (Ningxia) region, operated by NWCD.