Postgr
Christophe Pettus: All Your GUCs in a Row: fsync
2026-07-23 5 min PostgreSQL All Your GUCs in a Row: fsync fsync is a boolean, it defaults to on, and its context is…
Hub / programming / Planet PostgreSQL
programming · source
Planet PostgreSQL on WeSearch
Recent programming headlines from Planet PostgreSQL.
Lead story
Postgr
Christophe Pettus: All Your GUCs in a Row: gin_fuzzy_search_limit
2026-07-26 5 min PostgreSQL All Your GUCs in a Row: gin_fuzzy_search_limit The name is misleading twice over. It has nothing to do with fuzzy matching, the trigram-similarity, close-enough-spelling sense that people…
The latest
Postgr
Bruce Momjian: Postgres AI Workshop
New Presentation Thursday, April 30, 2026 I just gave a new presentation at PGDay Armenia titled Building an Mcp…
Postgr
Christophe Pettus: All Your GUCs in a Row: The geqo Family
All seven are user context, so any of them can be set per session, per role, or per database. The reason to take them…
Stormatics
SHRIDHAR KHANAL: The Right Way to Give a Third-Party DBA Access to Your PostgreSQL Database
July 23, 2026By Shridhar KhanalBlog, Service Security Hardening, Shridhar's Planet PostgreSQL The Right Way to Give a…
Postgr
Christophe Pettus: All Your GUCs in a Row: from_collapse_limit
2026-07-22 3 min PostgreSQL All Your GUCs in a Row: from_collapse_limit Almost nobody writes the query shape this…
Postgr
Ahsan Hadi: Hybrid Search in PostgreSQL: BM25, Sparse Vectors, and Reciprocal Rank Fusion
In my previous blog on the pgEdge Vectorizer and RAG Server, I showed how to build a semantic search pipeline using…
Postgr
Christophe Pettus: All Your GUCs in a Row: file_extend_method
2026-07-21 3 min PostgreSQL All Your GUCs in a Row: file_extend_method file_extend_method is an escape hatch wearing…
Postgr
Christophe Pettus: All Your GUCs in a Row: cluster_name
The article discusses the importance of the cluster_name parameter in PostgreSQL for distinguishing between multiple…
DEV Community
Shinya Kato: 5 PostgreSQL locking behaviors that trip people up
This article discusses five PostgreSQL locking behaviors that can lead to unexpected issues. It highlights how certain…
Postgr
Andrei Lepikhov: EXPLAIN Prettier, or Post-Processing Query Plans in Postgres
The article discusses the challenges of interpreting the EXPLAIN command output in PostgreSQL. It highlights the…
postgres-contrib.org
Cornelia Biacsics: Contributions for week 20, 2026
The PGConf.dev 2026 event took place from May 19-22, showcasing various contributions and speakers. Notable organizers…
Postgr
Christophe Pettus: All Your GUCs in a Row: client_min_messages
The article discusses the PostgreSQL parameter client_min_messages, which controls the verbosity of messages sent to…
Postgr
Christophe Pettus: All Your GUCs in a Row: client_connection_check_interval
The article discusses the PostgreSQL parameter 'client_connection_check_interval', which was introduced in version 14.…
Postgr
Christophe Pettus: A Correction: Snowflake Postgres Is Just Postgres
The article addresses a correction regarding Snowflake's Postgres offering. It clarifies that Snowflake Postgres is…
boringSQL | Supercharge your SQL & Postgre
Radim Marek: TOAST: Where PostgreSQL hides big values
PostgreSQL employs the TOAST mechanism to manage oversized attributes within its strict 8KB page limit. When a tuple…
Postgr
Christophe Pettus: pgvector 0.8.2 and the Trouble With Parallel HNSW
pgvector 0.8.2 has been released to address a critical buffer overflow vulnerability in parallel HNSW index builds.…
Postgr
Christophe Pettus: All Your GUCs in a Row: checkpoint_timeout and checkpoint_completion_target
The article discusses two key PostgreSQL parameters: checkpoint_timeout and checkpoint_completion_target. It explains…
Stormatics
semab tariq: How to Cut Over After a PostgreSQL Migration
The article discusses strategies for cutting over after a PostgreSQL migration. It outlines two main approaches:…
Postgr
Christophe Pettus: Table Access Methods Wake Up
The PostgreSQL Table Access Method (TAM) API is experiencing renewed interest with recent extensions. Two significant…
Postgr
Christophe Pettus: All Your GUCs in a Row: bytea_output
The article discusses the PostgreSQL configuration parameter bytea_output, which controls the format of binary data…
Postgr
Christophe Pettus: Patch PgBouncer Today
A new patch for PgBouncer, version 1.25.2, was released to address several vulnerabilities, notably CVE-2026-6664,…
Postgr
Christophe Pettus: All Your GUCs in a Row: bonjour and bonjour_name
The article discusses two PostgreSQL parameters, bonjour and bonjour_name, which were introduced in 2002 but have…
Postgr
Christophe Pettus: PostgreSQL 19 Beta: The Four Features You’ll Actually Feel
PostgreSQL 19 Beta introduces several significant features aimed at improving database operations. Key changes include…
Unleashing the Power of Postgres in Kubern
Gabriele Bartolini: CloudNativePG and Crunchy PGO: an honest, opinionated comparison
The article provides a comparison between CloudNativePG and Crunchy PGO, two popular open-source operators for…
Postgr
Christophe Pettus: All Your GUCs in a Row: block_size
The article discusses the PostgreSQL parameter 'block_size', which is fixed at 8192 bytes and cannot be changed at…
Postgr
Christophe Pettus: All Your GUCs in a Row: bgwriter_lru_maxpages and bgwriter_lru_multiplier
The article discusses two important PostgreSQL parameters, bgwriter_lru_maxpages and bgwriter_lru_multiplier, which…
Postgr
Christophe Pettus: Managed Postgres, Examined: Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL is a managed database service that runs unmodified community PostgreSQL on EC2 instances…
How WeSearch handles this source
WeSearch's declared handling of Planet PostgreSQL's content. Indexing, snippets, summaries, retrieval and training are separate questions — see the rights registry or read this source's machine-readable record.
Indexing: Allowed
Snippet: Allowed
AI summary: Limited
Retrieval / RAG: Not asserted
Model training: Not asserted
Commercial reuse: Not permitted