{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Default configuration","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/bbe6cd84\"></iframe>","width":"100%","height":180,"duration":1941,"description":"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.\nHere are links to a few things we mentioned: \nshared_buffers\nAndres Freund tweets about shared_buffers \nPGTune Leopard \nCybertec Configurator\npg_stat_statements\nJIT configuration\npostgresqlco.nf\nannotated.conf\nOtterTune\nwork_mem\nrandom_page_cost\nmax_connections\nWhat to log\nmax_wal_size\nWAL and checkpoint tuning episode \neffective_cache_size\nIntro to Performance Tuning and Optimization (EDB guide)\nmax_parallel_workers_per_gather \n\n------------------------\n\nWhat 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.\nIf you would like to share this episode, here's a good link (and thank you!)\n\nPostgres FM is brought to you by:\nNikolay Samokhvalov, founder of Postgres.ai\nMichael Christofides, founder of pgMustard\n\nWith special thanks to:\nJessie Draws for the amazing artwork ","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}