Nikolay and Michael discuss the default config — some tools and principles you can use to customise it, as well as several parameters you probably always want to change.
Here are links to a few things we mentioned:
- shared_buffers
- Andres Freund tweets about shared_buffers
- PGTune Leopard
- Cybertec Configurator
- pg_stat_statements
- JIT configuration
- postgresqlco.nf
- annotated.conf
- OtterTune
- work_mem
- random_page_cost
- max_connections
- What to log
- max_wal_size
- WAL and checkpoint tuning episode
- effective_cache_size
- Intro to Performance Tuning and Optimization (EDB guide)
- max_parallel_workers_per_gather
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork