David Rowley (@davidrowley_pg) 's Twitter Profile
David Rowley

@davidrowley_pg

PostgreSQL hacker working for Microsoft. Likes to make PostgreSQL go faster. When not working, you might find him in the mountains somewhere in New Zealand

ID: 1376360763816730626

calendar_today29-03-2021 02:31:24

92 Tweet

512 Followers

75 Following

Azure Database for PostgreSQL (@azuredbpostgres) 's Twitter Profile Photo

New post from David Rowley from the #PostgreSQL team at Microsoft, about what's new in the Postgres 16 query planner (aka optimizer) tl;dr ✅ PG16 has quite a few performance improvements to the query planner, this post walks through 10 of them techcommunity.microsoft.com/t5/azure-datab…

Melanie Plageman (@melanieplageman) 's Twitter Profile Photo

In David Rowley’s new blog post about planner improvements in #postgres 16, he provides example queries and plans for every optimization mentioned. It’s a great way to learn about planner if you’re new or to brush up on minimal repros if you’re seasoned

David Rowley (@davidrowley_pg) 's Twitter Profile Photo

If you're thinking of upgrading to PostgreSQL 16, I wrote this blog to help explain (with examples) what's changed since PG15 in the query planner/optimizer

Craig Kerstiens - Finger lime evangelist (@craigkerstiens) 's Twitter Profile Photo

This deep dive by David Rowley on PG16 improvements is great! citusdata.com/blog/2024/02/0… What I love just as much as him showing up in HN comments, not defending or deflecting just being there and taking input but also educating news.ycombinator.com/item?id=393108…

SQL Performance Tips (@sqlperftips) 's Twitter Profile Photo

This is one of these very few articles: short, relevant, clear. A MUST read for everybody—whether using PostgreSQL or not. It is generally good to see how these things work. Thank you David Rowley — for the patches too, of course! citusdata.com/blog/2024/02/0…

David Rowley (@davidrowley_pg) 's Twitter Profile Photo

Lukas of pganalyze gives a great summary (in video form) of a blog I published yesterday about what's improved in the PostgreSQL 16 query planner.

pg at Microsoft 💻✨ #pg_at_msft (@pg_at_msft) 's Twitter Profile Photo

Recent blog post from David Rowley from the Postgres team at Microsoft, which developers & users loved 💟 All about what's new 🤯 in the #PostgreSQL 16 query planner As SQL Performance Tips says, it's "short, relevant, clear. A MUST read for everybody" techcommunity.microsoft.com/t5/azure-datab…

David Rowley (@davidrowley_pg) 's Twitter Profile Photo

In just over a week, I'm getting a rare opportunity to tell my story about how I ended up working full-time on PostgreSQL. Many thanks to Claire Giordano ✨ and all the Talking Postgres team for making this happen. I'm looking forward to it.

David Rowley (@davidrowley_pg) 's Twitter Profile Photo

Thanks to Claire Giordano ✨ and the Talking Postgres team for giving me a chance to tell my story about how I ended up working full-time on PostgreSQL. There certainly wasn't a single defining moment, but likely a few key things that took me in that direction.

David Rowley (@davidrowley_pg) 's Twitter Profile Photo

One of the things I'm working on for PostgreSQL 18 is executor performance. Today I pushed a patch to add JIT support to increase the performance of generating hash values for Hash Join. Thanks to Andres Freund (Tech) for letting me know this needed attention. git.postgresql.org/gitweb/?p=post…

One of the things I'm working on for PostgreSQL 18 is executor performance. Today I pushed a patch to add JIT support to increase the performance of generating hash values for Hash Join. Thanks to <a href="/AndresFreundTec/">Andres Freund (Tech)</a> for letting me know this needed attention. git.postgresql.org/gitweb/?p=post…
David Rowley (@davidrowley_pg) 's Twitter Profile Photo

The 2nd CommitFest of Postgres 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!

The 2nd CommitFest of Postgres 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 &lt; 2024. This year we've had 64 already with 2 CFs to go!
David Rowley (@davidrowley_pg) 's Twitter Profile Photo

I had no idea until today that such a large part of the world didn't class Monday as the first day of the week. ISO8601 and RFC3339 say it's Monday. I always thought the term "weekend" was fitting for days 6 and 7, but that doesn't seem to fit as well in blue or green areas.

I had no idea until today that such a large part of the world didn't class Monday as the first day of the week. ISO8601 and RFC3339 say it's Monday.  I always thought the term "weekend" was fitting for days 6 and 7, but that doesn't seem to fit as well in blue or green areas.
Claire Giordano ✨ (@clairegiordano) 's Twitter Profile Photo

If you're a #PostgreSQL developer, community member, or curious user—you'll likely enjoy the #TalkingPostgres #podcast where we talk to people who work with Postgres—to learn why they do what they do & how they got there. Subscribe today so you'll never miss an episode!

If you're a #PostgreSQL developer, community member, or curious user—you'll likely enjoy the #TalkingPostgres #podcast where we talk to people who work with Postgres—to learn why they do what they do &amp; how they got there. Subscribe today so you'll never miss an episode!
POSETTE: An Event for Postgres 🌟 🎥 #PosetteConf (@posetteconf) 's Twitter Profile Photo

🐘 🤔 If you're interested in the #Postgres Query Planner, you'll love David Rowley's (David Rowley) #PosetteConf talk. Discover why David chose to talk about the Query Planner and more at: posetteconf.com/speakers/david… #postgresql #databases #OpenSource

David Rowley (@davidrowley_pg) 's Twitter Profile Photo

It was a pleasure to give a talk last week at POSETTE: An Event for Postgres 🌟 🎥 #PosetteConf about what's new in the PostgreSQL 18 query planner. There are some great new features in this release. youtube.com/watch?v=KoT253…