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
I like how easy it is now to get the new postgres.ai copilot for any PostgreSQL:
- One-click deployment in three modes – PaaS, BYOC, BYOM
- Easy access to dashboards at xxxxxx.pgai.watch by default – to dive into all the details
- "Resolve in Cursor" (or you can use Claude Code, Codex, etc.)
- One-click deployment in three modes – PaaS, BYOC, BYOM
- Easy access to dashboards at xxxxxx.pgai.watch by default – to dive into all the details
- "Resolve in Cursor" (or you can use Claude Code, Codex, etc.)
November 14, 2025 at 4:34 AM
I like how easy it is now to get the new postgres.ai copilot for any PostgreSQL:
- One-click deployment in three modes – PaaS, BYOC, BYOM
- Easy access to dashboards at xxxxxx.pgai.watch by default – to dive into all the details
- "Resolve in Cursor" (or you can use Claude Code, Codex, etc.)
- One-click deployment in three modes – PaaS, BYOC, BYOM
- Easy access to dashboards at xxxxxx.pgai.watch by default – to dive into all the details
- "Resolve in Cursor" (or you can use Claude Code, Codex, etc.)
November 14, 2025 at 1:49 AM
[Chart showing throughput progression from 3.9 TiB/hour to 35+ TiB/hour when involving more processes]
3/FIN
3/FIN
November 6, 2025 at 6:09 AM
[Chart showing throughput progression from 3.9 TiB/hour to 35+ TiB/hour when involving more processes]
3/FIN
3/FIN
this repo deserves more stars gitlab.com/postgres-ai/...
we aim to have most detailed and advanced monitoring for Postgres -- and it's FOSS because it's just a foundation of something bigger
(after 20 years with Postgres, next month will be the most exciting announcement of my career)
we aim to have most detailed and advanced monitoring for Postgres -- and it's FOSS because it's just a foundation of something bigger
(after 20 years with Postgres, next month will be the most exciting announcement of my career)
October 31, 2025 at 8:13 PM
this repo deserves more stars gitlab.com/postgres-ai/...
we aim to have most detailed and advanced monitoring for Postgres -- and it's FOSS because it's just a foundation of something bigger
(after 20 years with Postgres, next month will be the most exciting announcement of my career)
we aim to have most detailed and advanced monitoring for Postgres -- and it's FOSS because it's just a foundation of something bigger
(after 20 years with Postgres, next month will be the most exciting announcement of my career)
postgres_ai monitoring v0.8 is out – expert-level Postgres monitoring tool designed for humans and AI.
GitHub: github.com/postgres-ai/...
GitLab: gitlab.com/postgres-ai/...
New: vacuum progress, enhanced table stats, checkpointer&bgwriter + lots of small fixes and improvements.
GitHub: github.com/postgres-ai/...
GitLab: gitlab.com/postgres-ai/...
New: vacuum progress, enhanced table stats, checkpointer&bgwriter + lots of small fixes and improvements.
August 30, 2025 at 12:03 AM
postgres_ai monitoring v0.8 is out – expert-level Postgres monitoring tool designed for humans and AI.
GitHub: github.com/postgres-ai/...
GitLab: gitlab.com/postgres-ai/...
New: vacuum progress, enhanced table stats, checkpointer&bgwriter + lots of small fixes and improvements.
GitHub: github.com/postgres-ai/...
GitLab: gitlab.com/postgres-ai/...
New: vacuum progress, enhanced table stats, checkpointer&bgwriter + lots of small fixes and improvements.
to be fair, opus 4.1
August 7, 2025 at 9:24 PM
to be fair, opus 4.1
One more thing for today: rules/guidelines for working with @PostgreSQL in your favorite AI copilot - Cursor, Claude Code, or GitHub Copilot:
postgres.ai/rules
(memorize this URL)
Grab them to produce better code, schema designs. Improvement MRs are welcome.
postgres.ai/rules
(memorize this URL)
Grab them to produce better code, schema designs. Improvement MRs are welcome.
July 24, 2025 at 12:20 AM
One more thing for today: rules/guidelines for working with @PostgreSQL in your favorite AI copilot - Cursor, Claude Code, or GitHub Copilot:
postgres.ai/rules
(memorize this URL)
Grab them to produce better code, schema designs. Improvement MRs are welcome.
postgres.ai/rules
(memorize this URL)
Grab them to produce better code, schema designs. Improvement MRs are welcome.
the latest 3 PostgresFM episodes are "multi" something
all so different, and all were awesome discussions with our guests www.youtube.com/playlist?lis...
all so different, and all were awesome discussions with our guests www.youtube.com/playlist?lis...
July 18, 2025 at 11:57 PM
the latest 3 PostgresFM episodes are "multi" something
all so different, and all were awesome discussions with our guests www.youtube.com/playlist?lis...
all so different, and all were awesome discussions with our guests www.youtube.com/playlist?lis...
Following Supabase steps, we're launching our very first Launch Week! 🚀
5 days, 5 major releases of useful stuff for fast-growing startups running #PostgreSQL
postgres.ai/launch-week
What do you want Postgres AI to release?
5 days, 5 major releases of useful stuff for fast-growing startups running #PostgreSQL
postgres.ai/launch-week
What do you want Postgres AI to release?
July 18, 2025 at 8:44 PM
Following Supabase steps, we're launching our very first Launch Week! 🚀
5 days, 5 major releases of useful stuff for fast-growing startups running #PostgreSQL
postgres.ai/launch-week
What do you want Postgres AI to release?
5 days, 5 major releases of useful stuff for fast-growing startups running #PostgreSQL
postgres.ai/launch-week
What do you want Postgres AI to release?
Fully agree, temp tables can easily bring various issues if used often / in loaded systems, including obscurity of troubleshooting and perf. degradation, so often I recommend removing them.
Why would you want them and why regular tables would help?
(Via kmoppel.github.io/2025-06-03-y...)
Why would you want them and why regular tables would help?
(Via kmoppel.github.io/2025-06-03-y...)
June 8, 2025 at 9:21 PM
Fully agree, temp tables can easily bring various issues if used often / in loaded systems, including obscurity of troubleshooting and perf. degradation, so often I recommend removing them.
Why would you want them and why regular tables would help?
(Via kmoppel.github.io/2025-06-03-y...)
Why would you want them and why regular tables would help?
(Via kmoppel.github.io/2025-06-03-y...)
Computer science created software engineers
AI made them equal
AI made them equal
May 31, 2025 at 5:11 PM
Computer science created software engineers
AI made them equal
AI made them equal
thinking that it would be great to have WAL metrics in pg_stat_[all|user|sys]_tables. Working on a patch
May 23, 2025 at 1:15 PM
thinking that it would be great to have WAL metrics in pg_stat_[all|user|sys]_tables. Working on a patch
Claude 4 is out
Tried it, asking how to tune wal_compression
Boom:)
Beautiful massive hallucination.
We must be very careful with LLMs.
Tried it, asking how to tune wal_compression
Boom:)
Beautiful massive hallucination.
We must be very careful with LLMs.
May 22, 2025 at 9:01 PM
Claude 4 is out
Tried it, asking how to tune wal_compression
Boom:)
Beautiful massive hallucination.
We must be very careful with LLMs.
Tried it, asking how to tune wal_compression
Boom:)
Beautiful massive hallucination.
We must be very careful with LLMs.
Reviewing zero-downtime switchover script another engineer prepared, I noticed a strange comment, "pool_mode=paused"
Turned out it was suggested by ChatGPT
Now my favorite question to LLMs is: "how to start pgbouncer in already paused mode?"
Correct answer: it's not supported
Turned out it was suggested by ChatGPT
Now my favorite question to LLMs is: "how to start pgbouncer in already paused mode?"
Correct answer: it's not supported
May 16, 2025 at 7:20 AM
Reviewing zero-downtime switchover script another engineer prepared, I noticed a strange comment, "pool_mode=paused"
Turned out it was suggested by ChatGPT
Now my favorite question to LLMs is: "how to start pgbouncer in already paused mode?"
Correct answer: it's not supported
Turned out it was suggested by ChatGPT
Now my favorite question to LLMs is: "how to start pgbouncer in already paused mode?"
Correct answer: it's not supported
CNPG split-brain – it's even worse than I originally thought github.com/cloudnative-...
April 23, 2025 at 3:52 PM
CNPG split-brain – it's even worse than I originally thought github.com/cloudnative-...
Looking at yugabyte.com/blog/postgre... – great!
One thing (the same issue, as for RDS): "Blue/green" and "N" in the "Rollback" column contradict.
True B/G deployments *must* be symmetric, with rollback (without downtime and data loss) – this is 100% possible.
1/2
One thing (the same issue, as for RDS): "Blue/green" and "N" in the "Rollback" column contradict.
True B/G deployments *must* be symmetric, with rollback (without downtime and data loss) – this is 100% possible.
1/2
April 22, 2025 at 5:12 AM
Looking at yugabyte.com/blog/postgre... – great!
One thing (the same issue, as for RDS): "Blue/green" and "N" in the "Rollback" column contradict.
True B/G deployments *must* be symmetric, with rollback (without downtime and data loss) – this is 100% possible.
1/2
One thing (the same issue, as for RDS): "Blue/green" and "N" in the "Rollback" column contradict.
True B/G deployments *must* be symmetric, with rollback (without downtime and data loss) – this is 100% possible.
1/2
let's not miss this once-upon-a-time moment – 30y in a few weeks 🎉 github.com/snaga/postgr...
April 4, 2025 at 9:38 PM
let's not miss this once-upon-a-time moment – 30y in a few weeks 🎉 github.com/snaga/postgr...
nice words about #PostgresFM in postgresweekly.com/issues/595
April 3, 2025 at 7:17 PM
nice words about #PostgresFM in postgresweekly.com/issues/595
FINALLY, amcheck will (in PG18) be able to check GIN indexes – a long-awaited addition, kudos to all who were involved!
gitlab.com/postgres/pos...
commitfest entry existed since 2022 commitfest.postgresql.org/patch/3733/
gitlab.com/postgres/pos...
commitfest entry existed since 2022 commitfest.postgresql.org/patch/3733/
April 1, 2025 at 3:55 PM
FINALLY, amcheck will (in PG18) be able to check GIN indexes – a long-awaited addition, kudos to all who were involved!
gitlab.com/postgres/pos...
commitfest entry existed since 2022 commitfest.postgresql.org/patch/3733/
gitlab.com/postgres/pos...
commitfest entry existed since 2022 commitfest.postgresql.org/patch/3733/
Awesome read: 30 years of PostgreSQL buffer manager locking design evolution medium.com/@dichenldc/3...
March 29, 2025 at 10:21 AM
Awesome read: 30 years of PostgreSQL buffer manager locking design evolution medium.com/@dichenldc/3...