Skip to content
Hallway
0:00 / 0:00

#amazonaurora#rds#queryplanmanager

Deep Dive on Amazon Aurora PostgreSQL Performance Tuning

Amazon Web Services

849K subscribers • 14 videos on Hallway

YouTube
  • Recommended by 1 person: 1 in engineering communities.
  • Presented by James Finnerty, AWS
  • Made by the vendor. The company whose product it covers made or sponsored it.
  • May be out of date. Uploaded 7 years ago, in an area where tools change fast.

Intermediate. Assumes working knowledge.

26K views7 years ago1 recommendation

Databases and dataCloud and DevOpsPostgresAWSPerformance and optimization

James Finnerty explains how to optimize PostgreSQL performance on AWS, focusing on query plans and Amazon Aurora's query plan manager.

Learn more about Amazon Relational Database Service (RDS) at – amzn.to/2Umohok James Finnerty at AWS Migration Day - PostgresConf NYC, March 18, 2019

Why it's here

1 person recommends this

What people say. Recommended for its practical tips on optimizing PostgreSQL and understanding Aurora's query plan management.

u/O1O1O1Oin r/PostgreSQL • Recommends

Some tips on optimizing Postgres on Amazon including on Aurora I found the first half of this video quite informative on optimizing Postgres. The remaining half is mostly about optimizing on their Aurora solution using their query plan manager. link to this video Here are my unedited notes: ## Top problems seen in explain analyze - large diff in estimated vs actual rows can cause sort vs merge join - analyze? - index usage or not - large # of buffers read - not in mem - "lossy" bitmap heap scan - not enough work_mem - make functions immutable if appropriate ## Recommended PostgresSQL settings (for AWS) - random_page_cost: 1.0 at most 1.5 for SSD (4 for rotating media) - work_mem: up to '4GB' fo…
25View on Reddit