BM25 Full-Text Search in Postgres: pgx-bm25 Tutorial
pgx-bm25 1.0 puts Okapi BM25 ranking into a native Postgres index access method. Build it, index a table, and run ranked, boolean, proximity and snippet queries step by step.
Month: 2 weeks ago
pg_ivm 1.16: Stop Paying the REFRESH MATERIALIZED VIEW Tax
If your Postgres dashboard runs REFRESH MATERIALIZED VIEW on a schedule, you know the ritual: for a few seconds, readers queue behind a lock while the database recomputes a result it mostly already had. The fix is not a faster refresh. It is not refreshing at all. pg_ivm — the Incremental View Maintenance extension — […]
Pgpool-II Security Release Headlines October Postgres News
Pgpool-II patched seven CVEs across five branches on October 1. Plus: Aurora queries Iceberg directly, Supabase buys Turso, pgEdge launches Starfleet, and Dasha 1.8 ships index recommendations.
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.
Pgpool-II 4.7.3 Fixes 7 Watchdog CVEs: Patch Your HA Cluster
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.