Search Articles — Sudonull

Search Results

In this project

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.

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.

From other projects

Webb Explains Man Utd Penalty Decisions in Bournemouth Draw

https://lrivo.com/webb-explains-man-utd-penalty-decisions-in-bournemouth-draw

PGMOL chief Howard Webb clarifies why Man Utd got one penalty but not another vs Bournemouth. Get the full breakdown of the controversial refereeing calls.

Trending Now