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.
Sur cette page du site, vous pouvez voir la vidéo en ligne Default configuration | Postgres.FM 031 | durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur PostgresTV 01 janvier 1970, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 621 fois et il a aimé 22 téléspectateurs. Bon visionnage!
