Linux Sys Admin, Gentoo user, PostgreSQL advocate, Android fanboi, OSS supporter, PlayStation gamer.
Founder of @pgcmh
Optimising #PostgreSQL Aggregates: What Can an Extension Do? https://www.pgedge.com/blog/optimising-postgresql-aggregates-what-can-an-extension-do
www.pgedge.comOptimising PostgreSQL Aggregates: What Can an Extension Do?Generated SQL is full of redundant sorts no one can edit out. PostgreSQL 19 lets an extension strip them at plan time: a 10M-row sum drops from 5.7s to 3.7s. By Andrei Lepikhov.
hot_standby_feedback | #Postgres FM #podcast https://share.transistor.fm/s/d5f84484
share.transistor.fmhot_standby_feedback | Postgres FMNik and Michael discuss hot_standby_feedback — what it controls, whether and when read replicas should be changed to on, and other settings you can change to help too.
Here are some links to things they mentioned:
hot_standby_feedback...
The unbearable lightness of one more index #postgresql https://boringsql.com/posts/unbearable-lightness-of-one-more-index/
boringSQL | Supercharge your SQL & PostgreSQL powersThe unbearable lightness of one more indexThirty PostgreSQL schemas written by coding agents, loaded and measured. The indexes are competent; the cumulative cost is not.
All Your [#postgres] GUCs in a Row: max_connections https://thebuild.com/blog/all-your-gucs-in-a-row-max_connections/
thebuild.comAll Your GUCs in a Row: max_connections`max_connections` is a memory budget and a circuit breaker disguised as a capacity setting.
Chinese #PostgreSQL Docs Are Live: All 11 Major Versions https://vonng.com/en/pg/pgsql-cc-online/
VONNGChinese PostgreSQL Docs Are Live: All 11 Major Versionspgsql.cc is live, with Chinese documentation for all 11 PostgreSQL major versions from 10 through 20, a redesigned mirror of the official website, and better full-text search. Kept in sync with upstream, with no ads.
#Postgres recovery_prefetch Considered Harmful and Causing Outages https://ardentperf.com/2026/10/20/postgres-recovery_prefetch-considered-harmful-and-causing-outages/
Ardent Performance ComputingPostgres recovery_prefetch Considered Harmful and Causing OutagesAnother story of something I saw in the field which surprised me. Turns out recovery_prefetch can cause outages. Something which has been happening quietly in the background all the time, but we di…
30 Years of #Postgres Architecture: Tom Lane Interview https://www.snowflake.com/en/blog/engineering/30-years-of-postgres-architecture-tom-lane/
www.snowflake.com30 Years of Postgres Architecture: Tom Lane InterviewExplore 30 years of Postgres architecture with core committer Tom Lane. Learn about process isolation, MVCC, write-ahead logging, and threads.
All Your [#postgres] GUCs in a Row: max_active_replication_origins https://thebuild.com/blog/all-your-gucs-in-a-row-max_active_replication_origins/
thebuild.comAll Your GUCs in a Row: max_active_replication_originsPostgreSQL 18 finally gave replication origins their own parameter after a decade of borrowing space from `max_replication_slots`.
100,000 Lines of C Later: pgSafe at PGDay UK 2026 #postgres https://vyruss.org/blog/100000-lines-of-c-later-pgsafe-pgday-uk-2026.html
-=vyruss=- / blog100,000 Lines of C Later: pgSafe at PGDay UK 2026Yesterday I gave a talk at PGDay UK 2026 in London about pgSafe, a from-scratch Go rewrite of enterprise Postgres backups, and what pgBackRest's near-demise in April taught us. The talk covered what a backup tool really does, the invariants every backup tool has to uphold, my design tenets, where 100,000 lines of C went, and the parts no language can shrink.
All Your [#postgres] GUCs in a Row: logical_decoding_work_mem https://thebuild.com/blog/all-your-gucs-in-a-row-logical_decoding_work_mem/
thebuild.comAll Your GUCs in a Row: logical_decoding_work_memLogical decoding holds uncommitted transactions in memory until commit—and when they get too big, PostgreSQL spills them to disk.
All Your [#postgres] GUCs in a Row: maintenance_io_concurrency https://thebuild.com/blog/all-your-gucs-in-a-row-maintenance_io_concurrency/
thebuild.comAll Your GUCs in a Row: maintenance_io_concurrencyDiscover which PostgreSQL maintenance tasks actually use `maintenance_io_concurrency`—the answer is wider and more surprising than the name suggests, and…
All Your [#postgres] GUCs in a Row: maintenance_work_mem https://thebuild.com/blog/all-your-gucs-in-a-row-maintenance_work_mem/
thebuild.comAll Your GUCs in a Row: maintenance_work_memUnlock faster index builds and vacuum operations by understanding maintenance_work_mem: PostgreSQL's one-allocation memory budget that actually behaves like…
All Your [#postgres] GUCs in a Row: log_parser_stats, log_planner_stats, log_executor_stats, and log_statement_stats https://thebuild.com/blog/all-your-gucs-in-a-row-log_parser_stats-log_planner_stats-log_executor_stats-and-log_statement_stats/
thebuild.comAll Your GUCs in a Row: log_parser_stats, log_planner_stats, log_executor_stats, and log_statement_statsPostgreSQL's oldest logging parameters measure CPU time, page faults, and context switches per statement—crude but irreplaceable when you need to know why a…