PostgresAI
@postgres_ai
We build Self-Driving Postgres and help fast-growing startups scale their databases, workloads, and related operations
New episode: "max_connections vs migrations" Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!) 🎧 postgres.fm/episodes/max_c… 📺 youtu.be/KFRK8PiIvTg
postgres_ai monitoring v0.13: k8s support, new dashboard "13. lock contention", passwordless login from Console.Postgres.ai (Oauth with org verification), many fixes and improvements GitHub: github.com/postgres-ai/po… GitLab: gitlab.com/postgres-ai/po…
Added a new diagram to the postgres.ai front page showing how @postgres_ai copilot works: Your Postgres (located anywhere) → postgres_ai monitoring → Health check & Issues → GitHub PRs / AI tools → deployed back to your Postgres (continuous loop)…
New episode: "Tens of TB per hour" Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica. 🎧 postgres.fm/episodes/tens-… 📺 youtu.be/ff-goIbd-Zk
I like how easy it is now to get the new @postgres_ai copilot for any @PostgreSQL database: One-click deployment in three modes – PaaS, BYOC, BYOM Easy access to dashboards at xxxxxx.pgai.watch by default – in case you need to dive into all the details "Resolve in…
Reminder: DBLab Engine is available in AWS Marketplace Testing schema changes in production? Optimizing queries by guessing? Database branching solves this: - Instant preview environments - Safe query optimization - 100% CI coverage for DB changes
#PostgresMarathon 2-013: Why keep your index set lean Unused indexes are silent performance killers. They slow writes, bloat backups, and complicate query planning. In this post I explore 6 reasons to audit your indexes regularly – essential practices we always use in production…
postges_ai monitoring 0.12: SLRU, MultiXact member space exhaustion, many improvements and fixes GitHub: github.com/postgres-ai/po… GitLab: gitlab.com/postgres-ai/po…
Your Postgres TODO list has been the same for 6 months: □ Drop unused indexes □ Eliminate bloat □ Tune autovacuum □ Set up proper monitoring Today we're launching @postgres_ai – automated Postgres maintenance so your team can focus on shipping. PR/MR-based approvals.…
Stop fighting Postgres issues. Keep shipping features. Introducing new @postgres_ai, it takes care of your Postgres. Removes unused and redundant indexes, mitigates bloat — all automated with PR-based approvals for full control. Early access: postgres.ai
Stop fighting Postgres issues. Keep shipping features. Introducing new @postgres_ai, it takes care of your Postgres. Removes unused and redundant indexes, mitigates bloat — all automated with PR-based approvals for full control. Early access: postgres.ai
Resolved: This incident has been resolved. postgresai.instatus.com/cmhmz4bl906ads…
Identified: We are continuing to work on a fix for this incident. postgresai.instatus.com/cmhmz4bl906ads…
Investigating: We are currently investigating this incident. postgresai.instatus.com/cmhmz4bl906ads…
Redesigning @postgres_ai on the path to Self-Driving Postgres. First: tackling the problem most teams actually face: index maintenance, not index creation. Sad truth: everyone agrees when we show what needs to be done. But it's too much effort, so it sits in TODO forever.…
New episode: "Gapless sequences" Nik and Michael discuss the concept of gapless sequences — when you might want one, why sequences in Postgres can have gaps, and an idea or two if you do want them. 🎧 postgres.fm/episodes/gaple… 📺 youtu.be/3uIXr92GRWo
this repo deserves more stars github.com/postgres-ai/po… gitlab.com/postgres-ai/po… we aim to have the 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…
postgres_ai monitoring 0.11: VictoriaMetrics, lots of optimizations, new dashboards for table and index analysis, and more github.com/postgres-ai/po…
postgres_ai monitoring 0.11: VictoriaMetrics, lots of optimizations, new dashboards for table and index analysis, and more github.com/postgres-ai/po…
#PostgresMarathon 2-008: LWLock:LockManager and prepared statements As was discussed in #PostgresMarathon 2-002, for a simple SELECT from a table, at planning time, Postgres locks the table and all of its indexes with AccessShareLock. A simple demo to remind it (let me be a bit…
#PostgresMarathon 2-007: Should we worry about pg_blocking_pids()'s observer effect? Many years ago, when developing complex automated procedures for a large company, I realized that my automation needs monitoring components. Including understanding heavyweight lock contention –…
#PostgresMarathon is back! Make sure you follow me so we could learn some good stuff about @PostgreSQL together. This time, I'll be doing it a bit differently: - I'll choose one big @PostgreSQL topic that I'll be covering over a week or two - Every day, I'll be posting bits of…
United States Trendy
- 1. FINALLY DID IT 622K posts
- 2. The JUP 180K posts
- 3. Good Tuesday 39.9K posts
- 4. Susie Wiles 8,015 posts
- 5. Vanity Fair 2,733 posts
- 6. #PersonOfTheYearAwards2025 1.06M posts
- 7. #tuesdayvibe 2,678 posts
- 8. #MAGMA N/A
- 9. 4.6% in November 1,877 posts
- 10. #HeAProDriver 17.4K posts
- 11. Taco Tuesday 11.7K posts
- 12. Alex Delgado N/A
- 13. #KastNoToquesALosVenezolanos 1,691 posts
- 14. Boston Tea Party 1,143 posts
- 15. PERTHSANTA AVATAR GALA 544K posts
- 16. The BBC 127K posts
- 17. Namjoon 106K posts
- 18. Unemployment Rate 10.8K posts
- 19. Sheed N/A
- 20. Uber Eats 3,354 posts
Something went wrong.
Something went wrong.