Postgres 18.7 Forces Extensions to Move With the Server
PostgreSQL 18.7’s CVE-2026-6460 fix changes the interface between the server and compiled extensions. How to inventory, patch and reindex without breaking the database.
Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
PostgreSQL 18.7’s CVE-2026-6460 fix changes the interface between the server and compiled extensions. How to inventory, patch and reindex without breaking the database.
EnterpriseDB announced on November 5 that it has acquired Altinity, the main independent provider of enterprise support and managed services for ClickHouse, with integrated enterprise ClickHouse capabilities promised for Q4 2026. You can read the vendor claims yourself in the EDB press release. For a Postgres DBA the M&A is background noise. The useful signal […]
Pinecone’s pg_pinecone brings a native IVF and RaBitQ vector engine into Postgres 17 and 18. When to move a table off pgvector, and what to verify first.
pg_knowledge_base puts Oxigraph’s SPARQL engine inside PostgreSQL 19: triples in ordinary tables, R2RML over your existing rows, one transaction for both. What it costs, what it can’t do, and where it fits in Houston.
HNSW, StreamingDiskANN, and a new partition-plus-compression design: how to pick a Postgres vector index, fix filtered search, and keep it in RAM.
pg_plan_filter 1.0.0 refuses Postgres statements whose estimated plan cost is too high. How to install it, choose limits, and cap runaway batch work.
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.
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 […]
pg_partman 5.5.0 changed its background worker’s default role, and pg_cron 1.6.8 added Postgres 19 support. Here is how to run partition maintenance that does not go quiet.
Houston teams are past the pgvector demo stage. The prototype indexed a few hundred thousand embeddings, queries came back in single-digit milliseconds, and everyone moved on. Then the corpus grew — refinery maintenance manuals, upstream drilling reports, municipal permit records, or an e-discovery set — and the same index started losing recall, or the build […]