Jignesh Shah’s Post

PostgreSQL 17 RC1 is now available in Amazon RDS Database preview environment! https://lnkd.in/d43JT8bR #Amazon #RDS #PostgreSQL

PostgreSQL 17.0 is now available in Amazon RDS Database preview environment https://lnkd.in/gFDmmW6S #Amazon #RDS #PostgreSQL

PostgreSQL 17 Beta 1 is now available in Amazon RDS Database Preview Environment! Try it and give early feedback! https://lnkd.in/gEeeAZ_H #Amazon #RDS #PostgreSQL

PostgreSQL 17 Beta 3 is now available in Amazon RDS Database Preview environment! My favorite features: PostgreSQL 17 includes updates to vacuuming that reduces memory usage, improves time to finish vacuuming, and shows progress of vacuuming indexes. With PostgreSQL 17, you will no longer need to drop logical replication slots when performing a major version upgrade to a higher major version. https://lnkd.in/gUN5yVmp #Amazon #RDS #PostgreSQL

Amazon Aurora PostgreSQL-Compatible Edition now supports PostgreSQL major version 16 (16.1). PostgreSQL 16 adds support for SQL/JSON constructors and identity functions, more query types that can use parallelism, and the ‘pg_stat_io’ view that provides statistics on I/O usage. Please refer to the PostgreSQL community announcement for more details about the release. This release includes new features for Babelfish for Aurora PostgreSQL version 4.0 such as support for the Full Text Search CONTAINS function. Please refer to Amazon Aurora PostgreSQL updates for more information.

Amazon RDS for PostgreSQL, MySQL, and MariaDB now support M7g and R7g database instances in additional regions! With this regional expansion, Graviton3 database instances are now available for Amazon RDS in 16 regions https://lnkd.in/gqBX259v #Amazon #RDS #PostgreSQL #MySQL #MariaDB

MySQL 5.7 and PostgreSQL 11 databases on Amazon Aurora and Amazon RDS are set to elevate their performance with the automatic enrollment into Amazon RDS Extended Support! Starting TODAY. 📅 Key Dates Reminder: MySQL 5.7: Extended Support begins on March 1, 2024, lasting until February 28, 2027. Aurora MySQL 2: Extended Support starts on November 1, 2024, with charges from December 1, 2024. PostgreSQL 11: Extended Support initiates on April 1, 2024, concluding on March 31, 2027. Aurora PostgreSQL 11: Extended Support begins on March 1, 2024, with charges from April 1, 2024. Learn more: https://lnkd.in/gJ2carci #AWSExtendedSupport #Database #AWS

Amazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now support AWS Graviton3-based M7g and R7g database instances in US West (N. California), Asia Pacific (Hyderabad, Seoul), Canada (Central), Europe (London, Spain), and Middle East (Bahrain). Graviton3-based instances provide up to a 30% performance improvement and up to a 27% price/performance improvement (based on on-demand pricing) over Graviton2-based instances on RDS for open-source databases depending on database engine, version, and workload

Exciting new blog on "building a custom HTTP client in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL as an alternative to Oracle's UTL_HTTP". Check it out and let us know your thoughts! For Oracle customers migrating to Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL, this blog demonstrates how to convert UTL_HTTP referenced code using AWS Lambda and the Python Requests module Rajeshkumar Sabankar Vamsikrishna Jammula Sumana Yanamandra #aws #amazon #blogs #oracle #database #databasemigration #amazonrds #aurora #postgresql https://lnkd.in/ggxQ5DMz

Replicate data between partitioned and non-partitioned tables using trigger functions in Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL | Amazon Web Services https://buff.ly/4af8s6v