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 Tendencias
- 1. #Survivor49 14K posts
- 2. Disturbed 6,667 posts
- 3. Cartoon Network 1,632 posts
- 4. Newt 2,292 posts
- 5. Garfunkel N/A
- 6. Savannah 16.5K posts
- 7. #PresidentialAddress 15.1K posts
- 8. Kristina 4,459 posts
- 9. IT MATTERS 49.2K posts
- 10. Warrior Dividend 29.9K posts
- 11. Rizo 2,182 posts
- 12. Jake Allen N/A
- 13. #AEWDynamite 23.6K posts
- 14. #vampirenowtwt 14.3K posts
- 15. Cavs 7,722 posts
- 16. Jimmy Fallon 5,621 posts
- 17. Billie Eilish 12K posts
- 18. Davido 257K posts
- 19. Mr Beast 2,883 posts
- 20. Bernie Mac N/A
Something went wrong.
Something went wrong.