Emeric Tabakhoff’s Post

Andrei Lepikhov: PostgreSQL Sort estimation volnurability 🚀 PostgreSQL Geeks, gather around! 📊 Ever stumbled upon subtle quirks in the code? Andrei Lepikhov did, and boy, it's a doozy: Incremental Sort Estimation Instability. 🤯 Back in 2020, PostgreSQL got incremental sorts, a nifty feature designed to handle big data like a champ. But, as Andrei discovered, our beloved optimizer isn’t always nailing it. 🛠️🔍 Let’s play with a ‘test’ table. We’ve got unique values in column ‘x’ and constants in ‘y’. Try a few queries flipping left and right sides: ```sql SELECT count

Gülçin Yıldırım Jelínek: Prague PostgreSQL Meetup on November 18th 🎉 Exciting News, PostgreSQL Enthusiasts! 🎉 Mark your calendars for November 18th, because the Prague PostgreSQL Meetup is coming to town! 📅 And let me tell you, it's going to be more thrilling than your last query's EXPLAIN ANALYZE output. 😉 Join us for an event that's sure to boost your knowledge, like a well-tuned VACUUM FULL. Whether you're there to absorb wisdom or simply to network over some hot beverages, don’t miss out! Thanks to the amazing Gülçin Yıldırım Jelínek for organizing this gathering of PostgreSQL aficionados. Her efforts have more impact on our community than an efficient B-tree index on your largest table. 🙌 Whether you're a seasoned DBA who speaks fluent SQL or a newbie still figuring out the mysteries of pg_hba.conf, there's something here for everyone. Maybe you’ll even bump into someone who can finally clear up the myth of the missing semicolon. Swag? Probably. Puns? Definitely. So, if you're in Prague in November, you know where to go. After all, in the database world, NOVEMBER 18 is the new DEFAULT for optimization secrets. 😎 #PostgreSQL #DatabaseManagement #MeetupMadness #TechEvent #Prague2023 --- (And remember: in SQL as in life, you can't SELECT * FROM universe without encountering some NULLs.) You can find the full article here: https://postgr.es/p/6I7

🚀 Just dropped a new article! Check it out here: https://lnkd.in/gbvKegFj This one dives into the FILTER clause in Postgres and looks at different ways to tackle an SQL example, with FILTER as one of the cool options. This might be the grand finale of this article series on PostgreSQL. 🔒 Stay tuned for more fun stuff!

EDB is dedicated to sharing our knowledge and expertise with the Postgres community. This week, EDB Vice President and Postgres Evangelist Bruce Momjian will be at PGDay Chicago giving a talk on Postgres Query Optimizer, beyond joins and indexes. If you're attending the conference, we hope you'll have a chance to hear Bruce's talk and gain valuable skills for optimizing queries across various use cases. If you won't be in Chicago for the conference, you can still learn from Bruce. Check out the webinar replay linked below and enhance your understanding of PostgreSQL's underlying mechanics, and how database queries are optimized within Postgres, above and beyond the basics. https://bit.ly/3Wfbnbg #opensource #database #Postgres #PostgreSQL United States PostgreSQL Association #pgday

🚀 Unleash the true power of PostgreSQL with AlloyDB! Join our upcoming webinar on September 4th to see how Google's fully-managed PostgreSQL database service can revolutionise your database experience. Save your spot today → https://lnkd.in/dyNKFUee

🚀 Unleash the true power of PostgreSQL with AlloyDB! Join our upcoming webinar on September 4th to see how Google's fully-managed PostgreSQL database service can revolutionise your database experience. Save your spot today → https://lnkd.in/dyNKFUee

🚀 Unleash the true power of PostgreSQL with AlloyDB! Join our upcoming webinar on July 3rd to see how Google's fully-managed PostgreSQL database service can revolutionise your database experience. Save your spot today → https://lnkd.in/dKnyG35V

🚀 Unleash the true power of PostgreSQL with AlloyDB! Join our upcoming webinar on July 3rd to see how Google's fully-managed PostgreSQL database service can revolutionise your database experience. Save your spot today → https://lnkd.in/esc7hbRG

🚀 Unleash the true power of PostgreSQL with AlloyDB! Join our upcoming webinar on July 3rd to see how Google's fully-managed PostgreSQL database service can revolutionise your database experience. Save your spot today → https://lnkd.in/dgzhVKPj