Postgres FM

Monitoring checklist (dashboard 1): TPS and (optional but also desired) QPS Latency (query duration) — at least average. Better: histogram, percentiles Connections (sessions) — stacked graph of session counts by state (first of all: active and idle-in-transaction; also interesting: idle, others) and how far the sum is from max_connection (+pool size for PgBouncer). Longest transactions (max transa...

Here are links to a few things we mentioned:  Do you vacuum everyday? (talk by Hannu Krosing) Autovacuum tuning (EDB guide)  When autovacuum does not vacuum (2ndQuadrant blog post by Tomas Vondra)  Autovacuum tuning basics (old 2ndQuadrant blog post) Discussion with Anastasia Lubennikova (on RuPostgres, in Russian)   B-tree indexes (talk by Anastasia Lubennikova, in English)  Discussion with Peter...

Here are links to a few things we mentioned:  Three-valued_logic (Wikipedia) Postgres 15 improves UNIQUE and NULL (blog post by Ryan Lambert)  Practical SQL for Data Analysis — Interpolation (blog post by Haki Benita)  What is the deal with NULLs? (blog post by Jeff Davis)  NULL in SQL: Indicating the Absence of Data (Markus Winand on Modern SQL)  The Art of PostgreSQL (book by Dimitri Fontaine) ...

Here are links to a few things we mentioned:  EXPLAIN parameters (PostgreSQL documentation) EXPLAIN (ANALYZE) needs BUFFERS (blog post by Nikolay) Using BUFFERS for query optimization (blog post by Michael)   H3 indexes on PostGIS data (blog post by Ryan Lambert) Turning BUFFERS on by default (latest patch) pgMustard   explain.depesz.com explain.dalibo.com Database Lab Engine ---------------------...

Here are links to the two main resources we mentioned:  Paul Ramsey's recent blog post on BRIN indexes Tomas Vondra's slides on BRIN index improvements A few other things we mentioned: B-tree Wikipedia page   pg_repack   pg_squeeze   ------------------------ What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides If you would...

A well as discussing pros and cons, we mentioned a LOT of different providers and tools, and a few good articles/videos too. 😅 Here are links to most of them, roughly in the order they came up:  How Auto Trader migrated its on-prem databases to Cloud SQL PostgreSQL Community Panel: Upgradability Postgres TV Open Talks PostgreSQL Conference Europe Hannu Krosing — excellent vacuum talk pg_docs_bot...

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides If you would like to share this episode, here's a good link (and thank you!) We also have an uncut video version on YouTube . Postgres FM is brought to you by: Nikolay Samokhvalov, founder of Postgres.ai Michael Christofides, founder of pgMustard With special thanks to: J...