Grant McAlister

Amazon Aurora is a serverless relational database with unparalleled high performance and availability at global scale for PostgreSQL, MySQL, and DSQL. Aurora provides managed high availability (HA) and disaster recovery (DR) capabilities in and across AWS Regions.

With an innovative architecture that decouples compute from storage and advanced features like Aurora Global Database and low-latency read replicas, Aurora reimagines what it means to be a relational database.

In this session, learn why Netflix moved workloads from a self-managed, distributed PostgreSQL-compatible database on EC2 to Aurora, and how they operate 40TB+ today. Aurora shared storage eliminated cross-node coordination overhead, delivering up to 75% lower latency.

Amazon Aurora is a fully managed relational database designed for unparalleled high performance and availability at global scale with full MySQL and PostgreSQL compatibility. Aurora provides managed high availability (HA) and disaster recovery (DR) capabilities in and across AWS Regions.

With an innovative architecture that decouples compute from storage and advanced features like Amazon Aurora Global Database and low-latency read replicas, Aurora reimagines what it means to be a relational database.

In this session, learn to modernize legacy monolithic applications to microservices architectures and migrate large volumes of data using Amazon Aurora PostgreSQL. Features like Aurora Global Database, Optimized Reads, and Query Plan Management are integral to achieving high resilience and scalability.

This talk will first introduce the different ways PostgreSQL can use memory, from the operating system, to cluster wide and then into per session and per operation.

This talk will first introduce the different ways PostgreSQL can use memory, from the operating system, to cluster wide and then into per session and per operation. From there we will dive into specifics around different PostgreSQL parameters like shared_buffers, work_mem, maintenance_work_mem and how to set them depending on your workload.

Amazon Aurora is a fully managed relational database designed for unparalleled high performance and availability at global scale with full MySQL and PostgreSQL compatibility. Aurora provides managed high availability (HA) and disaster recovery (DR) capabilities in and across AWS Regions.

With an innovative architecture that decouples compute from storage and advanced features like Global Database and low-latency read replicas, Amazon Aurora reimagines what it means to be a relational database.

For many customers PostgreSQL logical replication has gone from a nice to have feature to a critical component in their application design and maintenance of their database. We will talk about how PostgreSQL logical replication has evolved to meet those needs and what are some of the current gaps.

This talk will first introduce the different ways PostgreSQL can use memory, from the operating system, to cluster wide and then into per session and per operation.

In this chalk talk, discover the factors affecting application resilience and learn about best practices that allow you to deploy workloads with enhanced resilience. Dive deeper into application design patterns, connection proxy mechanisms, and database tuning.

With an innovative architecture that decouples compute from storage as well as advanced features like Global Database and low-latency read replicas, Amazon Aurora reimagines what it means to be a relational database. The result is a modern database service that offers performance and high availability at scale, fully open-source MySQL- and PostgreSQL-compatible editions, and a range of...

Event-driven architecture is a software architecture promoting the production, detection, and consumption of events, as well as the reaction to them. It provides increased availability, elasticity, scalability, and cost optimization by promoting microservices, which are small, specialized services performing a narrow set of functions that can independently scale to meet demand.

The first portion of the session will cover the critical reason why PostgreSQL generates these full page writes (FPW) and how to monitor the rate of generation. Next we will demonstrate the negative effect of full page writes on performance, scale, backups and replication.

Amazon Aurora with PostgreSQL compatibility is a relational database managed service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source PostgreSQL. This session highlights Aurora with PostgreSQL compatibility’s key capabilities, including low-latency read replicas and Multi-AZ deployments; reviews the...

Amazon Aurora with PostgreSQL compatibility is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. In this session, we review the functionality in order to understand the architectural differences that contribute to improved scalability, availability, and durability.

In this session we will dive deep into HOT (Heap Only Tuple) update optimization. Utilizing this optimization can result in improved writes rates, less index bloat and reduced vacuum effort but to enable PostgreSQL to use this optimization may require changing your application design and database settings.