#PostgreSQL

2 articles tagged

Database server core on a dark surface with parallel light streams flowing in

Engineering · Jul 18, 2026 · 9 min read

Postgres 18 in production: async I/O tuning, uuidv7, and a safe upgrade in 2026

PostgreSQL 18 brings asynchronous I/O with up to 3x faster reads, time-ordered uuidv7, and RETURNING OLD/NEW. This 2026 guide covers io_method tuning, a uuidv4-to-uuidv7 migration, and the upgrade gotchas, from page

Manu Shukla

#PostgreSQL #database #async I/O

A Postgres database cube beside a dedicated vector index lattice, illustrating the RAG vector store choice

Engineering · Jul 16, 2026 · 11 min read

pgvector or a dedicated vector database? A RAG decision guide for 1M to 100M vectors

Most pgvector-versus-vector-database comparisons quote one vendor benchmark from April 2025 that ran no filtered queries and tested an extension most teams do not install. Here is what the primary sources actually

Manu Shukla

#RAG #PostgreSQL #vector-search