Schedule - PgDU 2019

8 PostgreSQL Performance Tips & Techniques

Date: 2019-11-15
Time: 11:25–12:05
Room: Conference Room
Level: Intermediate

OS: 1) THP & Defrag 2) I/O Scheduler

PG: 3) Tweak those Background processes Checkpoint BGwriter WALwriter Autovacuum 4) Connection Management & PgBouncer 5) Let’s Partition… Prune ‘em 6) High Availability - the parameter way… Let’s take them higher 7) pg_dump… dump it faster

Application: 8) Indexing and Data segregation

Bonus: Love those SSDs

Slides

The following slides have been made available for this session:

Speaker

Hari P Kiran