AWS Database Blog

July 2023: This post was reviewed for accuracy. The first post of this series, Resources consumed by idle PostgreSQL connections, talked about how PostgreSQL manages connections and how even idle connections consume memory and CPU. In this post, I discuss how idle connections impact PostgreSQL performance. Transaction rate impact When PostgreSQL needs data, it first […]

July 2023: This post was reviewed for accuracy. PostgreSQL is one of the most popular open-source relational database systems. With more than 30 years of development work, PostgreSQL has proven to be a highly reliable and robust database that can handle a large number of complex data workloads. AWS provides two managed PostgreSQL options: Amazon […]

Some applications require you to record changes to data over time, and you can identify these changes by a timestamp or number so it’s possible to retrieve specific versions later. In addition, you should be able to easily retrieve the most recent version and the design of the application to maintain data integrity as versions […]

AWS provides AWS organizations and AWS Landing Zone solutions to manage and automate new account creation. This helps you to create multiple AWS accounts separated based on applications, development, production, or organizations within a company. This approach helps with resource isolation and separating development from production, but makes it complex for some of the teams […]

Representational state transfer (REST) APIs are a common architectural style for distributed systems. They benefit from being stateless and therefore enable efficient scaling as workloads increase. These convenient—yet still powerful—APIs are often paired with database systems to give programmatic access to data managed in a database. One request that customers have expressed is to have […]

Keeping your database version up to date provides benefits like improved performance and security, access to new features, fixes to known issues, compliance with regulatory requirements, and more. However, there is also a risk of some queries experiencing performance regression following a database upgrade. This risk is higher with major version upgrades because they can […]

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. You can use the same MongoDB 4.0 or 5.0 application code, drivers, and tools to run, manage, and scale workloads on Amazon DocumentDB without having to worry about managing the underlying infrastructure. As a […]

December, 2022: Amazon Relational Database Service (Amazon RDS) now supports Amazon RDS Blue/Green Deployments to help you with safer, simpler, and faster updates to your Amazon Aurora and Amazon RDS databases. Blue/Green Deployments create a fully managed staging environment that allows you to deploy and test production changes, keeping your current production database safe. Learn […]

2020 has been another busy year for Amazon DynamoDB. We released new and updated features that focus on making your experience with the service better than ever in terms of reliability, encryption, speed, scale, and flexibility. The following 2020 releases are organized alphabetically by category and then by dated releases, with the most recent release […]

Amazon Relational Database Service (Amazon RDS) on VMware delivers managed SQL Server databases in on-premises VMware environments. Managing SQL Server can be complex and time-consuming, but RDS on VMware makes it easy to provision, scale, and operate SQL Server in VMware vSphere clusters. You can migrate your existing on-premises SQL Server databases to RDS on […]