Default configuration | Postgres.FM 031 |
Michael and Nikolay discuss the default config — some tools and principles you can use to customize it, as well as several parameters you probably always want to change.
Here are links to a few things we mentioned:
shared_buffers https://www.postgresql.org/docs/curre...
Andres Freund tweets about shared_buffers / 1438591082770563077
PGTune Leopard https://pgtune.leopard.in.ua/
Cybertec Configurator https://pgconfigurator.cybertec.at/
pg_stat_statements https://www.postgresql.org/docs/curre...
JIT configuration https://www.postgresql.org/docs/curre...
postgresqlco.nf https://postgresqlco.nf/
annotated.conf https://github.com/jberkus/annotated....
OtterTune https://ottertune.com/
work_mem https://www.postgresql.org/docs/curre...
random_page_cost https://www.postgresql.org/docs/curre...
max_connections https://www.postgresql.org/docs/curre...
What to log https://www.postgresql.org/docs/curre...
max_wal_size https://www.postgresql.org/docs/curre...
WAL and checkpoint tuning episode https://postgres.fm/episodes/wal-and-...
effective_cache_size https://www.postgresql.org/docs/curre...
EDB Intro to Performance Tuning and Optimization https://www.enterprisedb.com/postgres...
max_parallel_workers_per_gather https://www.postgresql.org/docs/curre...
-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.
On this page of the site you can watch the video online Default configuration | Postgres.FM 031 | with a duration of hours minute second in good quality, which was uploaded by the user PostgresTV 01 January 1970, share the link with friends and acquaintances, this video has already been watched 621 times on youtube and it was liked by 22 viewers. Enjoy your viewing!
