Just added – you can now ask Postgres.AI to visualize DB schema Try it out: console.postgres.ai

I was curious (and some customers requested it recently) what's up with alerts in PostgreSQL monitoring systems, what alerts could helpful in achieving better database health. Honestly, our "pgwatch2 Postgres.AI edition" is currently all about metrics and

How does planning time depend on the number of partitions? A simple DB experiment checking a PK lookup and number of partitions from 0 to 50, PostgreSQL 16: postgres.ai/chats/0191f21b…

"create me a script that will identify partitions within a table and further sub-partitions until the leaf partitions are reached" postgres.ai/chats/01922b83…

Nikolay Samokhvalov (Nik Samokhvalov): AI-assisted Postgres experiment: number of partitions vs. planning time postgr.es/p/6E6

AI-assisted Postgres experiment: number of partitions vs. planning time postgres.ai/blog/20241003-… The post has AI integration so you can ask questions or run your own variations of this experiment.

Confirmed with PostgresAI that there is no planning overhead at all from having too many partitions, for this trivial case with range partitioning and partitioning key based PK lookup, except for the very first query in a session. Did it by looking at the 2nd EXPLAIN in same

Pavlo showing demo of PostgresAI version of pgwatch dashboards and explaining different ideas around philosophy and vision. Awesome to see open source enabling active collaboration between people experimenting with different approaches to similar monitoring challenges.

📣 Scheduled maintenance: On Thursday, Dec 19 (14:00-19:00 UTC), we'll be performing updates to Postgres.AI Platform. Service will remain available with potential brief interruptions. We're working to minimize any impact.

The PostgresAI knowledge base is now being continuously updated. For example, emails from mailing lists like pgsql-performance or pgsql-hackers become known to our AI within 1h. So, when you ask postgres.ai about various Postgres questions, AI uses the most

Nik Samokhvalov PostgresAI Ha, cool, postgres.ai works! 😀 The last sentence was exactly what I was looking for (but was too lazy to look up as I haven't looked into PG codebase that much):

Postgres.AI mission: make the best Postgres expertise accessible to *any* engineer

Postgres.AI assistant was significantly recently optimized. This should be especially noticeable for all OpenAI models. And we have a few more optimizations planned. Try it out and let us know how it feels.

If you're on a managed PostgreSQL like RDS, would you be interested in exploring an alternative with me, to 1) drastically reduce costs, and 2) get full control of your database ? Vote! And if ready to act soon, reply "IN" and I'll reach out to discuss details

Postgres.AI is not accessible in Spain at the moment because of some decisions to block certain Cloudflare IPs

DBLab 4.0 sneak peek: full MacOS&ARM support is coming

DBLab Engine 4.0 Release Candidate (RC0) is out! 🌳 Database branching and snapshots on demand 🔄 Full refresh on demand ✨ Improved API, CLI, and UI 🍎 macOS ARM support (experimental) Available in Console.Postgres.AI Demo: demo.dblab.dev Feedback welcome!

I studied problems in several dozens of startups. Below is my list of Top-10 of Postgres-related issues that can look scary/annoying for a startup CTO. Don't wait until it put your project down – use this checklist to avoid hard problems before too late. 1/

DBLab Engine 4.0 RC2 is out: 🌳 Git-like database branching 📷 Snapshots on demand ♻️ Full refresh on demand ✨ Improved API, CLI, and UI 🍎 macOS ARM support (experimental) Available in Console.Postgres.AI Demo: demo.dblab.dev ("demo-token") Feedback welcome!

Resolved: This incident has been resolved. postgresai.instatus.com/cmc3s69gl001a9…