18 stories tagged with #pettus, in publish-time order across the WeSearch catalog. Tag pages update as new stories ingest.
⌘ RSS feed for this tag → or search "Pettus"
Christophe Pettus: All Your GUCs in a Row: The geqo Family
PostgreSQL's genetic query optimizer has seven knobs, but you should probably only touch one. Learn which one, and why the others are best left alone.…
Christophe Pettus: All Your GUCs in a Row: from_collapse_limit
Subqueries in FROM clauses get flattened into the outer query by default—but only if the resulting join problem stays small enough.…
Christophe Pettus: All Your GUCs in a Row: file_extend_method
file_extend_method is an escape hatch wearing the costume of a tuning knob. It exists for one purpose: to let you turn off a PostgreSQL 16 optimization on the filesystems where tha…
Christophe Pettus: All Your GUCs in a Row: cluster_name
cluster_name looks like a cosmetic label for process listings, but on a standby it silently becomes the name your primary uses to verify synchronous……
Christophe Pettus: All Your GUCs in a Row: client_min_messages
`client_min_messages` controls what your session sees, not what the server logs—a confusion that spawns most of its trouble.…
Knicks staff surprised fan with free tickets to Game 1 at Madison Square Garden
While waiting for the Madison Square watch party to start, a Knicks staff member randomly surprised 50-year-old Kareem Pettus and his wife Janet of Bedstuy, Brooklyn with playoff t…
Christophe Pettus: All Your GUCs in a Row: client_connection_check_interval
PostgreSQL 14 added a parameter that detects dead client connections during query execution, stopping wasted work before it's too late.…
Christophe Pettus: A Correction: Snowflake Postgres Is Just Postgres
Snowflake Postgres is community Postgres, not a fork with a proprietary storage layer—a correction to Wednesday's post on table access methods, and a closer……
Christophe Pettus: pgvector 0.8.2 and the Trouble With Parallel HNSW
pgvector 0.8.2 fixes CVE-2026-3172, a heap buffer overflow in parallel HNSW index builds that can leak data or crash the server.…
Christophe Pettus: All Your GUCs in a Row: checkpoint_timeout and checkpoint_completion_target
PostgreSQL's default 5-minute checkpoint interval wastes I/O on modern servers.…
Christophe Pettus: Table Access Methods Wake Up
PostgreSQL's Table Access Method API is finally seeing real action.…
Christophe Pettus: All Your GUCs in a Row: bytea_output
PostgreSQL's `bytea_output` parameter controls how binary data is formatted when sent to clients: the modern `hex` format (default since 9.0) or the legacy……
Christophe Pettus: Patch PgBouncer Today
PgBouncer 1.25.2 shipped a patch for a pre-authentication crash (CVE-2026-6664). Any TCP connection can take down your pooler. Patch this week.…
Christophe Pettus: All Your GUCs in a Row: bonjour and bonjour_name
PostgreSQL's Bonjour parameters let you advertise a server on the local network via Apple's service-discovery protocol—a clever 2002 idea that hasn't aged well.…
Christophe Pettus: PostgreSQL 19 Beta: The Four Features You’ll Actually Feel
PostgreSQL 19 beta arrives with four operational game-changers: 64-bit MultiXact Members kill a decades-old "vacuum or die" failure mode, parallel autovacuum……
Christophe Pettus: All Your GUCs in a Row: block_size
A parameter you cannot change. block_size lives in the “Preset Options” section of the docs, alongside its read-only cousins like data_checksums, wal_block_size…
Christophe Pettus: All Your GUCs in a Row: bgwriter_lru_maxpages and bgwriter_lru_multiplier
These two parameters close out the bgwriter cluster. Together with bgwriter_delay, they govern how the background writer decides what to write each round, and t…
Christophe Pettus: Managed Postgres, Examined: Amazon RDS for PostgreSQL
AWS runs unmodified PostgreSQL on EC2 instances, handling backups and failover via storage-layer replication. Learn what RDS actually is—and what it isn't.…