#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…
Glad to see a couple of @postgres_ai dashboards are now merged from our fork to upstream -- thanks @PavloGolub!
Pavlo Golub (@PavloGolub): pgwatch v4-beta is out! postgr.es/p/7cR
New episode: "Gadget's use of Postgres" Nik and Michael are joined by @harrybrundage from @gadget_dev to talk about zero-downtime major version upgrades, what they use Postgres for, their dream database, and more! 🎧 postgres.fm/episodes/gadge… 📺 youtu.be/PAgQRfgk87A
Seattle Postgres is starting our fall series with a big meetup! 6pm this Thu Sep 4 special guest @samokhvalov - founder of PostgresAI & co-host of postgres.fm - VERY lucky to have him as a guest! Please help repost to other social networks meetup.com/seattle-postgr…
New episode: "Disks" Nik and Michael discuss disks in relation to Postgres — why they matter, how saturation can happen, some modern nuances, and how to prepare to avoid issues. 🎧 postgres.fm/episodes/disks 📺 youtu.be/ajxMKRheORc
DBLab Engine v4.0.1 is out, it includes several important bug fixes; upgrade from v4.0.0 is highly recommended. Already available on AWS Marketplace: aws.amazon.com/marketplace/pp… GitHub: github.com/postgres-ai/da… GitLab: gitlab.com/postgres-ai/da…
postgres_ai monitoring v0.8 is out – expert-level Postgres monitoring tool designed for humans and AI. GitHub: github.com/postgres-ai/po… GitLab: gitlab.com/postgres-ai/po… New: vacuum progress, enhanced table stats, checkpointer&bgwriter + lots of small fixes and improvements.
Zero-downtime major upgrades are one of key components of our Self-Driving Postgres vision, and our methodology is already being battle-tested by multiple PostgresAI customers. @gadget_dev just shared their battle notes -- full transparency on what worked (and what surprised…
Special thanks to the @postgres_ai team for helping craft our approach and working with us through the upgrade!
Zero downtime Zero data loss Yandu, infra engineer at Gadget, details how we were able to use logical replication to execute a seamless Postgres major‑version upgrade without any maintenance windows or 500s gadget.dev/blog/zero-down…
New episode: "Monitoring from Postgres AI" Nikolay talks to Michael about Postgres AI's new monitoring tool — what it is, how its different to other tools, and some of the thinking behind it. 🎧 postgres.fm/episodes/monit… 📺 youtube.com/watch?v=c9LVai…
Full-stack preview environments with DBLab 4.0: isolated databases for every pull request postgres.ai/blog/20250724-…
Launch week day 4: Postgres how-tos – practical guides for real-world database challenges postgres.ai/blog/20250724-…
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.
Launch week day 3: @PostgreSQL AI Checkup service – expert-led, AI-assisted comprehensive database health assessment postgres.ai/blog/20250723-…
United States 트렌드
- 1. Flacco 84K posts
- 2. Bengals 80K posts
- 3. Bengals 80K posts
- 4. Tomlin 21.6K posts
- 5. Ramsey 18.9K posts
- 6. Chase 107K posts
- 7. Chase 107K posts
- 8. #WhoDey 6,805 posts
- 9. #TNFonPrime 5,543 posts
- 10. #WhoDidTheBody 1,519 posts
- 11. #clubironmouse 2,278 posts
- 12. Teryl Austin 2,765 posts
- 13. #criticalrolespoilers 7,011 posts
- 14. Cuomo 81.7K posts
- 15. yeonjun 109K posts
- 16. Andrew Berry 3,217 posts
- 17. DK Metcalf 3,947 posts
- 18. Max Scherzer 14.3K posts
- 19. Burrow 9,727 posts
- 20. Ace Frehley 96.7K posts
Something went wrong.
Something went wrong.