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…
postgresai.instatus.com
Console.Postgres.ai outage - Incident details - PostgresAI / DBLab - Status
Console.Postgres.ai outage - Incident details - PostgresAI / DBLab Status
Identified: We are continuing to work on a fix for this incident. postgresai.instatus.com/cmhmz4bl906ads…
postgresai.instatus.com
Console.Postgres.ai outage - Incident details - PostgresAI / DBLab - Status
Console.Postgres.ai outage - Incident details - PostgresAI / DBLab Status
Investigating: We are currently investigating this incident. postgresai.instatus.com/cmhmz4bl906ads…
postgresai.instatus.com
Console.Postgres.ai outage - Incident details - PostgresAI / DBLab - Status
Console.Postgres.ai outage - Incident details - PostgresAI / DBLab Status
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 Xu hướng
- 1. #heatedrivalry 60.9K posts
- 2. shane 80.7K posts
- 3. Good Friday 40K posts
- 4. Expedition 33 233K posts
- 5. ilya 64.5K posts
- 6. GOTY 76.3K posts
- 7. #TheGameAwards 463K posts
- 8. Bucs 24.8K posts
- 9. YOONMIN 23.6K posts
- 10. Kyle Pitts 20.4K posts
- 11. Falcons 39.2K posts
- 12. Mega Man 41.2K posts
- 13. #TheEndOfAnEra N/A
- 14. Todd Bowles 6,183 posts
- 15. Deadpool 39.3K posts
- 16. Silksong 54.4K posts
- 17. Leon 203K posts
- 18. Titanfall 6,824 posts
- 19. Geoff 75.9K posts
- 20. Rose 299K posts
Something went wrong.
Something went wrong.