Invitation from Ryan Booz Many of the PostgreSQL newbies that I’ve engaged with lately are coming from other databases often because of company priorities to start adopting Postgres and migrating projects. Inevitably, one of the first things they want to learn once data starts flowing is how to tune queries. They typically have a lot of experience doing this type of work previously, just not with Postgres. With that as the backdrop, the invitation for March is presented below. The Challenge For this month’s PGSQL Phriday, I’m asking you to discuss your process for tuning difficult queries. Spe ..read more

Invitation from Lætitia Avrot Lætitia is hosting for the second time, and the topic is sure to get a great discussion going – just like the first time she hosted and the conversation really Triggered some healthy debate. Lætitia’s invitation and challenge It’s sometimes difficult to find a great topic and I like the kind of topics where there is no consensus. This one is a little particular: in my humble opinion, the database community has a consensus, it’s that developers don’t agree. Let’s organize a debate between database people and developers! I hope this will lead to great conversation ..read more

Invitation from Pavlo Golub To finish out 2023, Pavlo is inviting us to think about PostgreSQL events and write about our experiences. While the world of in-person events started to open up again in 2022, there’s no doubt that 2023 has been really busy in all parts of the world, especially for our beloved PostgreSQL database. As a retrospective, and in anticipation of things to come, Pavlo’s invitation includes many different prompts to help you get started. And there’s no doubt that PostgreSQL users old and new will benefit from hearing your experience of how to get the most value out of atte ..read more

Invitation blog post by Henrietta Dombrovskaya and summary post of all submissions Quick aside from Ryan: In my opinion Hettie picked the perfect topic for the start of a new year! Please read the full invitation post linked above (it’s a great read!) and then contribute a post this month! We all have something to share and learn about more effectively managing and learning PostgreSQL! Now that I have expressed my frustration, here is what I would love to hear from other people in the World of PostgreSQL: Do you have any of your own scripts which make your life as a DBA/Database develo ..read more

Invitation from Ryan Booz and summary post of all submissions Woot! Woot! Can you believe it? We’ve made it one complete year! This is the final invitation for the first year of PGSQL Phriday! I’ll let the invitation blog and challenge summary speak for itself. Suffice it to say, PostgreSQL 16 is just around the corner!!! The challenge from Ryan On Friday, September 1, 2023, publish a post on your blog about something (or a group of things) that you’re excited about using when PostgreSQL 16 is released. Try to give some background on why this feature or improvement is important to you. Maybe ..read more

Invitation from Tomasz Gintowt We’re a little behind on the invitation this month, so there will certainly be some wiggle room for posting responses over the weekend into Monday. Remember, this is all volunteer work. Tomasz is a new PostgreSQL friend for me and I love the topic he’s picked: Partitioning vs. Sharding. There are so many approaches in the PostgreSQL community around how to effectively and efficiently keep data light and accessible, including different approaches in various PostgreSQL extensions and database-related projects. Let’s see how all of you approach this important data ..read more

Invitation from Alicja Kucharczyk and summary post of all submissions Quick story! Alicja was one of two people that hoped on an impromptu video call with me a few years ago after asking for some help connecting with the PostgreSQL community on Twitter. Since then, she and others like Andreas Scherbaum (host of PGSQL Phriday #002 and PostgreSQL Person of the Week) continue to pour lots of energy into the community. I’m thankful for their support and efforts. So many of us benefit daily from contributions like theirs! Now, onto the challenge for this month… The challenge from Alicja For this mo ..read more

Invitation from Dian M Fay and summary post of all submissions The host for this month’s event is Dian Fay, someone I’ve only met virtually because of some excellent content Dian has published for previous PGSQL Phriday blogging events. For me, that speaks to the power of these little monthly challenges, prompting a group of people to write about a common topic because we all learn so much from one another. I’ve been really blessed by the detail and thought process that Dian provides in each blog post. For the challenge this month, Dian is asking about a topic near and dear to me, managing dat ..read more

Invitation from Michael Christofides and summary post of all submissions Believe it or not, we’re now eight months into this PGSQL Phriday thing and I couldn’t be happier with the community support. So many really smart, thoughtful, and community-minded folks learning from and helping one another! This month, Michael Christofides of pgMustard is our host and he’s chosen pg_stat_statements as the topic. I’m really excited for Michael to host this month because he’s been such an encouragement to me throughout my PostgreSQL journey. Not long after I started using PostgreSQL again full-time, I we ..read more

Invitation from Lætita Avrot and summary post of all submissions Lætita is a long-time PostgreSQL DBA, developer, psql evangelist, and all-round contributor to the Postgres community. I always appreciate her approach to helping people learn about PostgreSQL and encouragement for folks to get involved. **Trigger warning**: This challenge is about… triggers! (sorry, I couldn’t resist) Check out the full invitation and “rules” for participating! I can’t wait to hear both sides of the debate! The challenge from Lætita Your mission, should you choose to accept it, is to write a blog post by Friday ..read more