pganalyze’s Post

🚀 New on Medium: Surprising Ways People Are Using PostgreSQL PostgreSQL is more than just a relational database—it’s a powerhouse that’s popping up in unexpected places. From serving as a Kubernetes datastore to powering feature flag tools like Unleash, Postgres is proving its versatility across the tech stack. Check out my latest Medium post where I dive into some of the most unique and unconventional use cases for Postgres. Whether you’re a seasoned dev or just curious about new tech, you might be surprised by what this open-source giant can do. 👉 https://lnkd.in/eSV8JP-Y

You can trust your data with Crunchy Data

If you haven't seen Crunchy Postgres for Kubernetes in action, here's a great opportunity to see everything it delivers for working with data in Kubernetes. I highly recommend registering for this upcoming webinar.

Crunchy Postgres for Kubernetes is pretty amazing. It comes with built-in high availability support. Here's a live demo - simulating a failure, while the application load stays steady and your database continues to operate. If you're curious to learn more and see this live in action join us for our upcoming webinar 📺 where we explore how do make your: Postgres unbreakable with high availability https://lnkd.in/gVCuY9yr

Check out our Crunchy Postgres for Kubernetes webinar and see how easy High Availability can be!

A large part of giving a successful talk is having a great, engaging story and being able to deliver it well. That's a given (nobody likes boring recitations!) But there's also KYA—Know Your Audience. If you are unsure who's coming, it could be a struggle to extract a story worth delivering. There are so many factors affecting who's actually going to be there in the room. I want to laser focus on those who are coming — literally. In a few weeks, I am delivering a talk on the challenges and prospects of developing sophisticated Postgres extensions (https://lnkd.in/gZnHR2gc), and I'd like to know who's coming. The mechanics are simple: comment to check-in/wave 👋 here if you are coming or would have come if you were attending Postgres Conference 2024 in San Jose. Come. There will be nice little surprises for those who checked in and came! See you there. I am looking forward to delivering the best talk that is tuned just for you. P.S. I don't have a perfect reach yet. Can you help me by sharing this post? 🙏

DynamoDB ➡️ Couchbase Trying #Couchbase just got even easier! You can now import your #DynamoDB data & indexes into Couchbase seamlessly via the command line or within your favorite IDE – cbmigrate CLI, Couchbase VSCode Extension, and JetBrains Plugin 👏. Get started: https://bit.ly/3yncNqz

Scaling Postgres 307 is released! In this episode, we discuss whether we should be using bytewise or linguistic ordering by default, how to transform data in Postgres, benefits of a transaction_timeout and how to enforce join order: https://lnkd.in/ebqmDS3B #Postgres #PostgreSQL

Continue the re:invent journey after a while! Vector database is talked everywhere and I am curious about how PostgreSQL works it. If you are also interested in this topic, this 400-level talk about pgvector is amazing. Jonathan Katz covered a lot, primarily including the considerations and best practices about pgvector indexing approaches and the techniques to fine-tune the performance. Dived really deep but in very friendly manner. The proof is that even I (as a layman in vector field) can understand most of them and found it fascinating!

"The 2nd CommitFest of #PostgreSQL 18 starts today. I noticed an increase in performance-related patches. The chart below shows the top 5 topics from the last decade of CFs. We've had ~40 performance patches committed per year < 2024. This year we've had 64 already with 2 CFs to go!" https://lnkd.in/eNuZKd8a