Nik Samokhvalov
@samokhvalov.bsky.social
Talk to me if you have issues with your Postgres databases: nik@postgres.ai // I stand with Ukraine // Postgres.AI & DBLab & Postgres.FM
FOSS killed Oracle’s grip on the enterprise AI is about to do the same to RDS Spent an hour today with a customer moving ~100 PG clusters off RDS Backups & HA aren't hard anymore. What's needed is an AI observability + ops layer -- to keep DBs healthy at scale Data layer is repatriating
I wish Postgres 19 would be renamed to Postgres 26. Just easier to track.
I wish Postgres 19 would be renamed to Postgres 26. Just easier to track.
suddenly prototyped almost everything TimescaleDB has on top of PgQue
What a nice blog post Christophe Pettus: PgQue: Two Snapshots and a Diff thebuild.com/blog/2026/05...
PgQue: Two Snapshots and a Diff
PgQue's zero-mutation queue algorithm eliminates the "queue death spiral" by replacing UPDATE-and-DELETE with snapshot diffing.
thebuild.com
Working on PgQue is a lot of fun. Here I shared how it all started, what the original PgQ already had and what didn't, and what PgQue v0.2 brings (RC1 stamped yesterday) www.youtube.com/watch?v=bBNc...
PgQue | Postgres.FM 179 | #PostgreSQL #Postgres podcast
YouTube video by PostgresTV
youtube.com
Cache of raw SQL results is a famous anti-pattern. I can see a limited set of cases it can be useful though. Very limited.
PgQue roadmap (now in README) 0.2 coming soon, with lots of changes
Time to fully automate reindexing. Not only for btree - for all Working on leandex, an "anti-extension" for reindexing
"Just use a Postgres table as a queue" is advice that leads to pain in loaded systems Unless you pick the right one PGMQ: millions of dead tuples under a 6-min idle-in-tx storm. PgQue: flat at zero. Today I'm releasing PgQue v1 -- Skype's battle-tested 20y old PgQ, repackaged for modern Postgres
time to have a queue system in postgres, a good one
rpg 0.11.0 🦀🐘 ✨ Almost perfect (>95%) psql compatibility 🧪 Native psql regression tests in CI 🔎 Better \d* describe coverage and correctness 🌐 Experimental WASM/browser build 🎨 Better EXPLAIN highlighting 🔐 Better startup connection / SSL info + a bunch of fixes and small improvements 1/2
Releases · NikolayS/rpg
rpg — modern Postgres terminal written in Rust. psql-compatible, with built-in DBA diagnostics and AI assistant - NikolayS/rpg
github.com
The next version of rpg is going to have virtually 100% compatibility with psql – rich set of original tests Postgres source code has is super helpful. It was huge work during 4 days or so to reach that
"postgres pathology" -- what are the first things that come to your mind?
Hacking Postgres session LIVE – join! We continue looking at super interesting methodology and new tooling: precise wait event tracing www.youtube.com/watch?v=6kqp...
Hacking Postgres with Dmitry, Kirk, Nik – precise wait event tracing, part 2
YouTube video by PostgresTV
youtube.com
if you build something for open-source, keep it open
went to github.com/trending/developers to find profiles to track on gitzette.online, bumped into someone it's already tracking
how old is psql? fun fact: the command-line interface tool psql was added to PostgreSQL in 1994 with the release of Postgres95 and the "father" of psql, "POSTGRES terminal monitor", is from 1993: github.com/kelvich/post...
github.com
agentic hacking of Postgres with Andrey, Kirk, and Nik -- command tag customization—protocol-level negotiation via _pq_.command_tag_format www.youtube.com/live/VKuxQZl...
Agentic Hacking Postgres with Andrey, Kirk, and Nik: command tag customization
YouTube video by PostgresTV
youtube.com
pg_ash v1.3 released -- Active Session History for Postgres, pure SQL. New in 1.3: - pg_cron now optional, works with external schedulers - set_debug_logging(), RAISE LOG per sampled session - pgss-dependent functions fail fast when no pgss - Azure compatibility github.com/NikolayS/pg_...
