I was just working to make a query in a sample database more efficient when I realized something was off in the EXPLAIN plan. Apparently, somewhere along the way, I removed some GiST indexes on geography columns and... they're like important or something? 🤦🏻‍♂️😂

Are you a #sqlserver DBA or developer? Join our full-day #postgresql intro workshop with @ryanbooz.bsky.social at #techbash 2025! Every 4-day registration includes a workshop. Learn more at techbash.com #database #techevent #developers #data #kalahari #poconos #devconf #nepa #dba #familyfun

Headed to #Stirtrek2025. Always fun to get diverted because of weather. It's been quite a few days with weather related things!

Big shoutout to Hettie! She's such a force for good in the Postgres community and a works tirelessly to serve her dedicated user group in Chicago. Please consider supporting this new initiative and attending PGDay Chicago on April 25!

It's one thing to post slides after a talk, but this is next level! Detailed content between each slide from www.linkedin.com/in/karenhjex/ recent talk at DoK Day Europe: "Postgres on Kubernetes for the Reluctant DBA"

Introducing pgNow: A free, point-in-time diagnostic tool for #PostgreSQL created by @Redgate that helps you identify key performance metrics and configuration optimizations in your running Postgres instance.

The bees were loving the nice, warm, early spring day. They were not, however, happy that I was trying to include them into my promo videos for the book. 😂 (They aren't normally like this, btw. I often spend a lunch break observing them closely. They're just protective in early spring)

This was a big week for me & @gfritchey.bsky.social with the release of our book about #PostgreSQL! We're both thrilled & excited for this milestone! Here's a quick introduction from my perspective on why we wrote the book & who it's for. #JustUsePostgres www.softwareandbooz.com/on-writing-a...

It is not safe to have an open bag of pretzels and Herlocher's dipping mustard around me. Fortunately, the pretzel bag was only about 1/4 full.

I did not expect to see these little ladies out and about yesterday with 4.5°C/42°F temps. But, with the first clear day in a while and 10x warmer temperatures than a week ago, I'm sure it felt like a heat wave to them too! Almost makes me believe spring will come someday! 🐝🌻

If you have attended the #PASSDataSummit, fill out the survey on topics for 2025. Redgate will donate to a charity for every response. reg.passdatacommunitysummit.com/surveys/redg...

🎉🎉 #1 New Release on Amazon!!! 🎉🎉 Well this certainly is exciting... and unexpected! Introduction to PostgreSQL for the data professional, the book @gfritchey.bsky.social and I wrote, is the #1 new release in the Servers category on Amazon! And it's not even released yet!

Oh, I know it looks so sunny and nice outside at #CodeMash... But it was a balmy 4°f/-15.5°c when I woke up this morning. And, with the wind chill, it was certainly below 0°f. 🥶🥶🥶

I had a great crowd of 💯 #CodeMash attendees join me this morning to learn more about getting started with #PostgreSQL. Every time I present, the questions & interactions keep me energized, & *at least* one question stumps me & searching for answers. It keeps this amazing database fresh & new.

Hey #CodeMash, who's ready to learn about #PostgreSQL tomorrow morning? There's also a chance to get a pre-release copy of the new book by @gfritchy and me. 😀 8am in Nile... See you there!

A day and two hours later than I had hoped to leave for #CodeMash, but finally on the move to arrive late tonight! Let's goooooo!

Updating some #Postgres training for upcoming conference and internal sessions, and I never cease to be amazed at what a global community of developers can accomplish when they share the same passion for creating something useful and amazing. Today, for no specific reason, indexes are my focus...

Just used CoPilot to take a (simple) SQL Server schema script and convert it to PostgreSQL for a training example. Convert syntax, CamelCase->snake_case, SPROCs->PostgreSQL functions, & other syntax changes on function definitions. A couple of prompts and saved me 20min of manual work. #helpfulAI

Had a call yesterday with a friend that is returning to a previous company to start a greenfield project. Life-long SQL Server user that's slowly gaining #PostgreSQL experience. Without any prompting, he mentions Postgres is the likely database of choice for the new project. #JustUsePostgres

The monthly Postgres Meetup for All is happening today at 1PM EST (6PM GMT/10AM PST) for a discussion about Postgres & DuckDB with Josef Machytaka. Start 2025 meeting old & new #Postgres friends while learning about exciting new Postgres technology!

Ooooo... just got an email that the CFP for @stirtrek.com 2025 is just around the corner! Great one-day conference in Columbus, OH and well worth the visit. Top-notch speakers, topics, and... movies! --> www.stirtrek.com

Working on some new #Postgres talks to submit to upcoming conferences. I love working through ideas, but I hate how long it takes to narrow things down to a digestible length that still has value. Any non-AI topic suggestions for new/mid-level users that you feel haven't been covered well lately?

It's the first full week of 2025. If you're a #Postgres user & aren't subscribed to these resources, check them out! Your future self will thank you! Postgres Weekly (https://buff.ly/2S4Qevz) Planet Postgres: (https://buff.ly/40koLfQ) Postgres.FM Podcast Talking Postgres: (https://buff.ly/4fLYMlN)