pg_pinecone vs. pgvector: Choosing a Postgres Vector Engine
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.
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.
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_restore exiting 0 is not the finish line. A Postgres restore needs statistics, a visibility map, integrity checks and cutover gates before traffic — here is the runbook, with measured numbers.
Install the hdr_histogram extension, compute p50/p99/p99.9 over real rows, store per-minute histograms, and merge them losslessly across windows and hosts.
HypoPG 1.4.4 lets you test Postgres index ideas in a plain EXPLAIN before paying the write cost. What changed, the workflow, and where the extension lies to you.
Three PostgreSQL projects published release news on the same day this week, and they share more than a date. pgrecon 0.7.3 inventories an Oracle schema before anyone commits to a migration. BackupDrill turns “did the backup actually restore?” into a scheduled job that produces evidence. DBtune 4.0 pushes its tuning advice out of server parameters […]
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.
A default GUC on nearly every PostgreSQL standby can turn a brief network glitch into a 30-minute write outage. How recovery_prefetch amplifies replica IOPS, and how to decide whether to keep it.
pgBackRest 2.60.0 makes invalid page checksums a hard error on restore and expire. A step-by-step tutorial to find corruption before a restore does.
pg_hint_plan 1.9.0 is the first release built on PostgreSQL 19’s path generation strategies. How to inventory your hints, test hinted versus unhinted plans, and delete the ones that no longer earn their keep.
PostgreSQL 19 RC 1 shipped October 15, but general availability moved to November 19 with a second release candidate. What was reverted, what stayed, and what to test before you upgrade.