Default configuration

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 

Creators & Guests

Host

Michael Christofides

Founder of pgMustard

Host

Nikolay Samokhvalov

Founder of Postgres AI

What is Postgres FM?

A weekly podcast about all things PostgreSQL