Tag: database

PostgreSQL 16 Beta 1 is Now Available in Amazon RDS Database Preview Environment

Amazon RDS for PostgreSQL 16 Beta 1 is now available in the Amazon RDS Database Preview Environment, allowing you to evaluate the pre-release of PostgreSQL 16 on Amazon RDS for PostgreSQL. You can deploy PostgreSQL 16 Beta 1 in the Amazon RDS Database Preview Environment that has the benefits of a fully managed database, making […]

Amazon RDS for PostgreSQL supports minor versions 15.3, 14.8, 13.11, 12.15, and 11.20

Amazon Relational Database Service (RDS) for PostgreSQL now supports the latest minor versions PostgreSQL 15.3, 14.8, 13.11, 12.15, and 11.20. We recommend you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of PostgreSQL, and to benefit from bug fixes, performance improvements, and new functionality added by the PostgreSQL community. […]

Amazon RDS now supports M6i and R6i database instances in 16 new regions

Amazon Relational Database Service (RDS) now supports M6i and R6i in US East (N. Virginia, Ohio), US West (Oregon, N. California), Europe (Ireland, London, Paris, Stockholm, Milan, Frankfurt), Asia Pacific (Mumbai, Seoul, Hong Kong, Singapore, Tokyo, Sydney), Canada (Central), South America (São Paulo), Africa (Cape Town), and Middle East (Bahrain).

Amazon RDS now supports M7g and R7g database (DB) instances

AWS Graviton3-based M7g and R7g database instances are now generally available for Amazon Relational Database Service (RDS). Graviton3-based instances provide up to a 30% performance improvement and up to a 27% price/performance improvement over Graviton2-based instances on RDS for open-source databases depending on database engine, version, and workload. You can launch these database instances when […]

AWS Glue Crawlers now support creating partition indexes

AWS Glue Crawlers extract the data schema and partitions from Amazon S3 and populate the AWS Glue Data Catalog, keeping metadata current. Today, AWS Glue Crawler support is expanded to automatically add partition indexes for newly discovered tables that will help analytics services such as Amazon Athena and AWS Glue to optimize partition processing to help […]

Amazon RDS events now include tags for filtering and routing

Amazon Relational Database Service (Amazon RDS) events now include tags in the message body, which provide metadata about the resource that was affected by the service event. The message receiver can use these tags to do payload-based parsing with rule matching, enabling workflows such as routing, filtering, and down stream automation.

Amazon Redshift enhances string query performance by up to 63x

Today, Amazon Redshift introduced additional performance enhancements that speed up string-based data processing by 5x to 63x compared to alternative compression encodings such as LZO or ZSTD. Amazon Redshift achieves this through vectorized scans over light weight CPU-efficient dictionary-encoded string columns that allows the database engine to operate directly over compressed data. These techniques are […]

Amazon RDS Optimized Reads now offers up to 2X faster queries on RDS for PostgreSQL

Amazon Relational Database Service (Amazon RDS) for PostgreSQL now supports Amazon RDS Optimized Reads for up to two times faster query processing compared to previous generation instances. Complex queries that utilize temporary tables, such as queries involving sorts, hash aggregations, high-load joins, and Common Table Expressions (CTEs) can now execute up to two times faster […]

Amazon Aurora now supports PostgreSQL 15

Amazon Aurora PostgreSQL-Compatible Edition now supports PostgreSQL major version 15 (15.2). New features in PostgreSQL 15 include the SQL standard “MERGE” command for conditional SQL queries, performance improvements for both in-memory and disk-based sorting, and support for two-phase commit and row/column filtering for logical replication. Please refer to the PostgreSQL community announcement for more details […]