iiinova — where your digital self keeps evolving

Nik Samokhvalov @samokhvalov.bsky.social · 23/05/2026

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

010

Nik Samokhvalov @samokhvalov.bsky.social · 20/05/2026

I wish Postgres 19 would be renamed to Postgres 26. Just easier to track.

000

Nik Samokhvalov @samokhvalov.bsky.social · 20/05/2026

I wish Postgres 19 would be renamed to Postgres 26. Just easier to track.

000

Nik Samokhvalov @samokhvalov.bsky.social · 09/05/2026

suddenly prototyped almost everything TimescaleDB has on top of PgQue

011

Nik Samokhvalov @samokhvalov.bsky.social · 08/05/2026

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...

youtube.com

PgQue | Postgres.FM 179 | #PostgreSQL #Postgres podcast

YouTube video by PostgresTV

010

Nik Samokhvalov @samokhvalov.bsky.social · 02/05/2026

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.

000

Nik Samokhvalov @samokhvalov.bsky.social · 02/05/2026

PgQue roadmap (now in README) 0.2 coming soon, with lots of changes

000

Nik Samokhvalov @samokhvalov.bsky.social · 28/04/2026

Time to fully automate reindexing. Not only for btree - for all Working on leandex, an "anti-extension" for reindexing

020

Nik Samokhvalov @samokhvalov.bsky.social · 17/04/2026

"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

120

Nik Samokhvalov @samokhvalov.bsky.social · 16/04/2026

cooking – PostgresAI database health matrix

100

Nik Samokhvalov @samokhvalov.bsky.social · 14/04/2026

time to have a queue system in postgres, a good one

000

Nik Samokhvalov @samokhvalov.bsky.social · 14/04/2026

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

github.com

Releases · NikolayS/rpg

rpg — modern Postgres terminal written in Rust. psql-compatible, with built-in DBA diagnostics and AI assistant - NikolayS/rpg

100

Nik Samokhvalov @samokhvalov.bsky.social · 06/04/2026

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

010

Nik Samokhvalov @samokhvalov.bsky.social · 01/04/2026

"postgres pathology" -- what are the first things that come to your mind?

000

Nik Samokhvalov @samokhvalov.bsky.social · 25/03/2026

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...

youtube.com

Hacking Postgres with Dmitry, Kirk, Nik – precise wait event tracing, part 2

YouTube video by PostgresTV

001

Nik Samokhvalov @samokhvalov.bsky.social · 25/03/2026

if you build something for open-source, keep it open

000

Nik Samokhvalov @samokhvalov.bsky.social · 23/03/2026

went to github.com/trending/developers to find profiles to track on gitzette.online, bumped into someone it's already tracking

000

Nik Samokhvalov @samokhvalov.bsky.social · 13/03/2026

Ready for self-driving Postgres?

000

Nik Samokhvalov @samokhvalov.bsky.social · 13/03/2026

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

000

Nik Samokhvalov @samokhvalov.bsky.social · 12/03/2026

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...

youtube.com

Agentic Hacking Postgres with Andrey, Kirk, and Nik: command tag customization

YouTube video by PostgresTV

000

Nik Samokhvalov @samokhvalov.bsky.social · 12/03/2026

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_...

000

Nik Samokhvalov @samokhvalov.bsky.social · 25/02/2026

[Vibe] Hacking Postgres with Andrey, Kirk, Nik: AI or not AI; GSoC 2026; improving pglz compression -- LIVE now, join! www.youtube.com/watch?v=woTq...

youtube.com

[Vibe] Hacking Postgres with Andrey, Kirk, Nik - AI or not AI; GSoC 2026; improving pglz compression

YouTube video by PostgresTV

000

Nik Samokhvalov @samokhvalov.bsky.social · 05/01/2026

I really love `llm` by @simonw – and it plays nicely with our open-source checkup for Postgres. Example: pipe any health check into llm for instant analysis: npx postgresai@beta checkup <DB-URL> \ --json \ --check-id H001 \ | llm

010

Nik Samokhvalov @samokhvalov.bsky.social · 03/01/2026

ultra-small engineering teams – 1-3 humans – might become a big trend this year

010

Nik Samokhvalov @samokhvalov.bsky.social · 31/12/2025

if everyone is cooking, it's time to create awesome cookbooks

111

Nik Samokhvalov @samokhvalov.bsky.social · 31/12/2025

zero data loss highest performance always available If you'd need to choose only 2 of these 3 for your production PostgreSQL.. What's your preference ?

100

Nik Samokhvalov @samokhvalov.bsky.social · 27/12/2025

Is the DBA role cooked? What about DBRE -- does it suit AI era? Who owns Postgres expertise now, in teams without DBA and without DBRE? How do we call non-DBA engineers that grow Postgres expertise? What tools do they need?

021

Nik Samokhvalov @samokhvalov.bsky.social · 21/12/2025

If you're still manually reviewing pg_stat_statements, you're mass-producing burnout. The best DBAs I know automated this years ago. They focus on architecture and principles. The machine watches for problems. That’s the gig now.

010

Nik Samokhvalov @samokhvalov.bsky.social · 19/12/2025

Building the self-driving Postgres we always wanted

000

Nik Samokhvalov @samokhvalov.bsky.social · 15/12/2025

One of the areas we adjust with almost every singe customer is reconfiguration of log_xxx parameters – this is simple and needs to be done proactively in each startup, to have data for future RCAs defaults are not enough!

000

Nik Samokhvalov @samokhvalov.bsky.social · 13/12/2025

Making Postgres slower as a service is it a good idea? cloud.google.com/blog/product...

000

Nik Samokhvalov @samokhvalov.bsky.social · 13/12/2025

BYOx is the new term (invented by claude in cursor during postgres_ai copilot development) -- it means "bring your own anything" can be cloud (BYOC) can be your own machine (BYOM) can be nothing -- we'll do it for you (our cloud) this is the way

000

Nik Samokhvalov @samokhvalov.bsky.social · 12/12/2025

We went full in with monospace web What started as local redesign of PostgresAI Console's left menu in line with copilot workflow (Monitoring → Checkup/Issues → PR/MR → Monitoring), turned out to be full redesign of the whole Console. Rolled out to all 11k+ users And I like at a lot dark mode WIP

000

Nik Samokhvalov @samokhvalov.bsky.social · 10/12/2025

among all similar screenshots you can see today, this one is out of questions

000

Nik Samokhvalov @samokhvalov.bsky.social · 06/12/2025

quick check of pg18 pgbench on my new m5 macbook pro with 10 vcpus – not bad, 0.5M select-only TPS 50k in-mem SELECTs per core is actually good -- for example 4th-gen EPYCs showed only ~10k per core postgres.fm/episodes/fou...

000

Nik Samokhvalov @samokhvalov.bsky.social · 01/12/2025

Just sent first 100 invites to PostgresAI copilot Senior DBA on autopilot Cyber Monday deal still open Want in? DM me

010

Nik Samokhvalov @samokhvalov.bsky.social · 01/12/2025

"hit/read ratio" should be called "hit/(hit + read) ratio" so the math matches or hit/nullif(hit + read, 0) to be safe

000

Nik Samokhvalov @samokhvalov.bsky.social · 29/11/2025

Added a new diagram to the postgres.ai front page showing how PostgresAI copilot works: Your Postgres (located anywhere) → postgres_ai monitoring → Health check & Issues → GitHub PRs / AI tools → deployed back to PG (Inspired by turbopuffer's clean design; it rotates 90° on mobile.)

000