AWS Database Blog

When you migrate from Oracle to Amazon Aurora PostgreSQL-Compatible Edition or Amazon Relational Database Service (Amazon RDS) for PostgreSQL, you may need to deal with partitioned tables and ensure global uniqueness across partitions. Oracle Database supports global indexes. A global index contains keys from multiple table partitions in a single index partition. Each table partition […]

Amazon Timestream is a fully managed, scalable, and serverless time series database service that makes it easy to store and analyze trillions of events per day. Customers across a broad range of industry verticals have adopted Timestream to derive real-time insights, monitor critical business applications, and analyze millions of real-time events across websites and applications. […]

In OLTP databases, the buffer cache is memory allocated for storing cached data and dirty pages. Cached data speeds up the retrieval of frequently accessed information, and reading from these cached pages minimizes disk I/O operations. Setting appropriate values for shared_buffers is important for optimal PostgreSQL performance and can lead to significant reductions in overall […]

There are multiple examples of geospatial data use cases that most of us encounter on a daily basis. From maps, to weather, to tracking software on phones, geospatial data is all around us. In this post, we explore a use case of a ride sharing app and show the ease of working with geospatial data […]

In today’s data-driven world, JSON (JavaScript Object Notation) has emerged as a popular format for exchanging and storing data due to its simplicity and flexibility. As a result, database systems have evolved to include native support for JSON data types, enabling developers to work with JSON seamlessly within their applications. Oracle’s PL/JSON, an open-source package, […]

It’s important to understand strategies for how to use pgvector with your Generative AI applications so you can find the optimal configurations. This can include the selection of your database instance family, how you ingest your data, and even the version of pgvector you’re using. We ran a series of tests to see how pgvector […]

Monitoring is an important aspect of database management. Database administrators, application teams, and architects want to proactively eradicate performance issues before they affect users or cause an outage. To achieve this, they need the right level of visibility into database health indicators. Amazon Relational Database Service (Amazon RDS) provides monitoring tools, such as Enhanced Monitoring […]

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open-source databases. Global Database is an Aurora feature designed for globally distributed applications, allowing a single Amazon Aurora database to span multiple AWS Regions. A Global […]

When thinking about modernizing an Oracle Database to an open-source database on AWS, options include Amazon Relational Database Service (Amazon RDS) for MySQL, Amazon RDS for MariaDB, Amazon RDS for PostgreSQL, or Amazon Aurora. The choice of target database is usually dependent on three major factors: Database conversion or refactoring efforts The enterprise-wide decision on […]

Generative AI is a form of artificial intelligence (AI) that is designed to generate content, including text, images, video, and music. In today’s business landscape, harnessing the potential of generative AI has become essential to remain competitive. Foundation models are a form of generative AI. They generate output from one or more inputs (prompts) in […]