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
D
Author
Dinesh
Founder, CortexRidge
15+ years leading database engineering teams. Built and operated PostgreSQL platforms across AWS, Oracle (OCI PostgreSQL), Tessell, OpenSCG, and EnterpriseDB. Author of the PL/pgSQL book. Now building CortexBolt at CortexRidge.
Articles
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
Workflows in Practice: Disk Space Monitoring
One webhook call checks a server's disk, records the reading, alerts the customer, and archives the run. A five-node CortexBolt workflow, step by step.
Dinesh4 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
Fifteen years of databases, end to end
Fifteen years of database platforms at AWS, Oracle, Tessell, OpenSCG, and EnterpriseDB — and how they became CortexBolt, the autonomous operations platform.
Dinesh4 min read