Pacific Crest Trail: The postgresql.conf from A-Z
Joshua D. Drake
Joshua (JD) Drake is the President and CTO of Command Prompt, Inc., the oldest Postgres Company. He is also the Founder and Co-Chair of Postgres Conference (PostgresConf), the largest non-profit Postgres Community and Ecosystem conference. The founder of United States PostgreSQL (PgUS) and a Director for PgCentral, Inc. He has been using, deploying and extending PostgreSQL and related technologies since 1997.
No video of the event yet, sorry!
Everybody uses it, almost nobody knows what each parameter means. Just like the Pacific Crest Trail, most people have heard of it but few people have taken the 3-4 months to seek inner peace and understanding by hiking this gorgeous section of the United States. Let's take a 3-4 hour hike and explore the postgresql.conf. We will cover the desert of memory settings, to the mountains of the background writer and autovacuum. We will walk the Sierras of random_page_cost and experience the sunsets of effective_cache_size. From A-Z, you will walk away from this training with a firm understanding of the postgresql.conf.
- 3 h
- PGConf US 2017 [PgConf.US]