Ryan Booz
@ryanbooz.bsky.social
@PostgreSQL and DevOps Advocate @Redgate.
Chilly morning + hot coffee + new #Techbash mug = 💯
Thanks to everyone I got to meet and connect with the last few days at @Techbash.bksy.cosial. Sorry to miss the last day, but I'm sure it's going to be 🔥!!
Thanks to everyone I got to meet and connect with the last few days at @Techbash.bksy.cosial. Sorry to miss the last day, but I'm sure it's going to be 🔥!!
November 7, 2025 at 4:15 PM
Chilly morning + hot coffee + new #Techbash mug = 💯
Thanks to everyone I got to meet and connect with the last few days at @Techbash.bksy.cosial. Sorry to miss the last day, but I'm sure it's going to be 🔥!!
Thanks to everyone I got to meet and connect with the last few days at @Techbash.bksy.cosial. Sorry to miss the last day, but I'm sure it's going to be 🔥!!
I can't believe it's been a year ago already that @gfritchey.bsky.social & I taught our Introduction to Postgres precon at PASS Data Summit & Bruce Momjian was able to join us for a bit.
Not surprisingly, Bruce engaged with everyone afterwards, carrying on the conversation for another 30 minutes!
Not surprisingly, Bruce engaged with everyone afterwards, carrying on the conversation for another 30 minutes!
November 5, 2025 at 9:54 PM
I can't believe it's been a year ago already that @gfritchey.bsky.social & I taught our Introduction to Postgres precon at PASS Data Summit & Bruce Momjian was able to join us for a bit.
Not surprisingly, Bruce engaged with everyone afterwards, carrying on the conversation for another 30 minutes!
Not surprisingly, Bruce engaged with everyone afterwards, carrying on the conversation for another 30 minutes!
Hey #Techbash2025!
If you're planning to come to my @techbash.bsky.social precon to learn about PostgreSQL, here's a quick rundown of the Postgres install and sample database I'll be using if you want to try and follow along.
Install instructions: github.com/ryanbooz/blu...
youtu.be/mxFQiIFtNM0
If you're planning to come to my @techbash.bsky.social precon to learn about PostgreSQL, here's a quick rundown of the Postgres install and sample database I'll be using if you want to try and follow along.
Install instructions: github.com/ryanbooz/blu...
youtu.be/mxFQiIFtNM0
Techbash 2025: Postgres Precon Prerequisites
youtu.be
November 3, 2025 at 3:05 PM
Hey #Techbash2025!
If you're planning to come to my @techbash.bsky.social precon to learn about PostgreSQL, here's a quick rundown of the Postgres install and sample database I'll be using if you want to try and follow along.
Install instructions: github.com/ryanbooz/blu...
youtu.be/mxFQiIFtNM0
If you're planning to come to my @techbash.bsky.social precon to learn about PostgreSQL, here's a quick rundown of the Postgres install and sample database I'll be using if you want to try and follow along.
Install instructions: github.com/ryanbooz/blu...
youtu.be/mxFQiIFtNM0
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?
🤦🏻♂️😂
Apparently, somewhere along the way, I removed some GiST indexes on geography columns and... they're like important or something?
🤦🏻♂️😂
August 20, 2025 at 4:50 PM
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?
🤦🏻♂️😂
Apparently, somewhere along the way, I removed some GiST indexes on geography columns and... they're like important or something?
🤦🏻♂️😂
Reposted by Ryan Booz
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
Every 4-day registration includes a workshop. Learn more at techbash.com
#database #techevent #developers #data #kalahari #poconos #devconf #nepa #dba #familyfun
May 15, 2025 at 11:54 AM
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
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!
May 1, 2025 at 8:03 PM
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!
Please Welcome Prairie Postgres!
In this post, I want to formally introduce Prairie Postgres, a project that has kept me really busy for the past several months. The most important mission of Prairie Postgres is creating Postgres …
postgr.es
April 2, 2025 at 3:15 PM
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"
Postgres on Kubernetes for the Reluctant DBA
Slides and transcript from my talk, "Postgres on Kubernetes for the Reluctant DBA", at Data on Kubernetes Day Europe in London on 1 April 2...
postgr.es
April 2, 2025 at 1:03 PM
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.
Introducing pgNow: A free, point-in-time diagnostic tool for PostgreSQL
pgNow is a free, cross-platform desktop tool created by Redgate that helps you identify key performance metrics and configuration optimizations in your running Postgres instance. Available now as a…
buff.ly
March 10, 2025 at 2:02 PM
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)
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)
March 5, 2025 at 6:20 PM
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)
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...
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...
On Writing a Book About PostgreSQL
“Publishing a book is an amazing experience. Writing a book is very, very hard.” Louis Davidson, Simple Talk Editor (@drsql) At the risk of burying the lede… “Introduction to PostgreSQL for the dat…
www.softwareandbooz.com
February 7, 2025 at 8:06 PM
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...
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.
February 4, 2025 at 8:42 PM
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! 🐝🌻
Almost makes me believe spring will come someday! 🐝🌻
January 31, 2025 at 10:55 PM
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! 🐝🌻
Almost makes me believe spring will come someday! 🐝🌻
Reposted by Ryan Booz
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...
reg.passdatacommunitysummit.com/surveys/redg...
reg.passdatacommunitysummit.com
January 28, 2025 at 6:33 PM
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...
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!
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!
January 28, 2025 at 2:03 PM
🎉🎉 #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!
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.
🥶🥶🥶
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.
🥶🥶🥶
January 15, 2025 at 8:15 PM
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.
🥶🥶🥶
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.
January 15, 2025 at 7:51 PM
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!
8am in Nile...
See you there!
January 14, 2025 at 11:37 PM
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!
8am in Nile...
See you there!
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...
Today, for no specific reason, indexes are my focus...
January 10, 2025 at 8:15 PM
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...
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
A couple of prompts and saved me 20min of manual work.
#helpfulAI
January 10, 2025 at 7:57 PM
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
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
#JustUsePostgres
January 10, 2025 at 4:15 PM
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
#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!
Postgres & DuckDB with Josef Machytka, Wed, Jan 8, 2025, 1:00 PM | Meetup
This talk explores how can DuckDB enhance PostgreSQL workflows for ad-hoc data analysis, ETL processes, cross-database queries, rudimentary migrations and similar tasks. By
buff.ly
January 8, 2025 at 1:21 PM
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
--> www.stirtrek.com
Tech & a Flick - Stir Trek
Stir Trek is a one-day conference in Columbus, Ohio focused on teaching software developers the latest and greatest in technologies, techniques, and tools. The full day of content is always concluded…
www.stirtrek.com
January 8, 2025 at 9:03 AM
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
--> 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?
Any non-AI topic suggestions for new/mid-level users that you feel haven't been covered well lately?
January 7, 2025 at 2:27 PM
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?
Any non-AI topic suggestions for new/mid-level users that you feel haven't been covered well lately?