DuckDB in Postgres: Query S3, Iceberg Without an ETL Pipeline
AWS embedded DuckDB in Aurora PostgreSQL for direct Iceberg and Parquet queries. Here is the SQL that works, plus pg_duckdb 1.1.1 for self-hosted Postgres.
Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
PostgreSQL on this site is the main hub for everything related to designing, running, and improving modern Postgres databases. It brings together practical guidance on performance tuning, real‑world architecture patterns, learning resources, and hands‑on examples so developers and DBAs can get more out of PostgreSQL in production. From book recommendations and beginner tutorials to deep dives into scaling, extensions, and advanced features, this category is where readers go to level up every aspect of their Postgres stack.
AWS embedded DuckDB in Aurora PostgreSQL for direct Iceberg and Parquet queries. Here is the SQL that works, plus pg_duckdb 1.1.1 for self-hosted Postgres.
Seven CVEs, six of them in watchdog: the Pgpool-II subsystem that owns quorum, the delegate IP, and backend promotion. How to patch a live watchdog cluster one node at a time and harden the watchdog plane while you are in there.
Install Dasha 1.8 against your Postgres fleet with a read-only role, then use index recommendations, schema lint and the pg_stat_io I/O page safely.
PgBouncer 1.26.0 fixes three pre-auth DoS CVEs and adds per-database query_wait_timeout plus pool_idle_timeout. Here is how to tune both for tail latency.
PostgreSQL 19 Beta 4 landed on September 24, 2026 — right on the date the project’s own schedule named. The headline is not a feature that arrived. It is four that left. Per the release announcement, this beta reverted SQL/PGQ property graph query support, online enabling and disabling of data checksums, temporal updates and deletes […]
Every RAG prototype works on twenty documents. Then the real corpus shows up with its real shape: maintenance procedures that cite API 610, drilling reports that name a PZ-7 mud pump, permits and work orders full of tag numbers. Ask a pure vector index for “PZ-7 liner torque” and it cheerfully returns five documents about […]
Most failover drills end the same way: the standby takes over, applications reconnect, and everyone goes home. The part that quietly broke is backup continuity. A community question summarized this week by Stefan Fercot on his pgBackRest blog describes exactly this: a standby was promoted with archive_mode=off, and the team wanted to avoid restarting the […]
Step-by-step setup for pgsql-test: seed an ephemeral Postgres database, test row-level security in both directions, and assert on triggers and constraint violations inside your existing test runner.
pg_stat_statements evicts least-executed statements, splits or merges queryids by parse tree, hides nested work, and has no application_name column. A DBA triage guide for Postgres 17, 18, and 19.
PostgreSQL 19 slipped past its usual September GA. Here’s the new schedule, the features that were reverted, and how Houston DBAs should re-plan the upgrade window.