SQL vs PL/pgSQL in PostgreSQL: Plan Caching
SQL vs PL/pgSQL functions in PostgreSQL 16: why a SQL function is re-planned on every loop call, how to reduce plan time.
Dinesh8 min read
Category
PostgreSQL
5 articlesAll CortexRidge writing in this category. Newest first.
ALTER FUNCTION SET work_mem: Fixing PostgreSQL Disk Spills Without a Global Change
Use PostgreSQL ALTER FUNCTION SET work_mem to stop one function's sorts spilling to disk without a global change. A production fix: 150 GB a day to 0.
Dinesh5 min read
pgsonify: Hearing PostgreSQL Health as Elephant Sounds
pgsonify is an experimental MIT-licensed tool that sonifies PostgreSQL health metrics as real elephant recordings. How it maps stats views to sound.
Dinesh5 min read
The Cost of Storing and Indexing Embeddings in pgvector
What does it cost to store and index embeddings in pgvector? Four costs priced per vector, and why keeping the HNSW index in RAM is the one that sets the bill.
Dinesh16 min read
PostgreSQL LISTEN/NOTIFY Is Not Durable — Here's the Fix with pg_durable
PostgreSQL LISTEN/NOTIFY loses messages when nobody is listening. See how pg_durable adds durable signals and workflows that survive restarts.
Dinesh8 min read