PG_EXPECTO Prompt vs GENTLEMAN: PostgreSQL Analysis https://sudonull.com/pg-expecto-prompt-vs-gentleman-postgresql-analysis
Comparison of detailed PG_EXPECTO prompt and universal GENTLEMAN v10.2 for PostgreSQL load reports. Test results on DeepSeek, key metrics SPEED and iowait. Learn why detail wins. For DBA.
pgvector vs pgvectorscale vs VectorChord: comparison https://sudonull.com/pgvector-vs-pgvectorscale-vs-vectorchord-comparison
Technical comparison of PostgreSQL extensions for vector search: pgvector, pgvectorscale, VectorChord. Benchmarks, HNSW/DiskANN indexes, RaBitQ compression. Docker setup and code for 1M records. Choose the optimal solution.
PostgreSQL Analysis: Epistemological Approach to Performance Incidents https://sudonull.com/postgresql-analysis-epistemological-approach-to-performance-incidents
How to Combine PG_EXPECTO Technical Analysis with Philosophical Methodologies for Reliable Incident Diagnosis. Quantifying Confidence and Critical Thinking Methods.
Open source PostgreSQL backups on Go https://sudonull.com/open-source-postgresql-backups-on-go
Self-hosted tool for pg_dump with notifications, health checks and monitoring. Avoid data loss like in a real case with $1500/mo. Install on VPS or cloud in minutes.
PostgreSQL Recovery without 2.5 TB Backup https://sudonull.com/postgresql-recovery-without-2-5-tb-backup
Real case of PostgreSQL cluster destruction from WAL deletion and SIGKILL. Recovery steps with ignore_system_indexes, crash_info and pg_dump patches. Lessons for 1C DBA.