On the company side, we're happy to welcome our newest team member, Nico, who joined us in January to lead sales. If you want to talk to us about purchasing pganalyze, or are interested in a demo, you can reach out through our Contact Us page, or reply back to this email. And, if compliance is on your mind: Our SOC 2 Type 2 report for 2023 is now available!
As always, you will also find other product updates, and all recent "5mins of Postgres" episodes in this newsletter.
All the best,
Lukas
New in pganalyze: Built-in assessment whether updates are HOT capable
We've launched a new feature in pganalyze to show you when updates on a table's column are HOT capable.
Not sure what that means? Heap-Only Tuples, aka HOT, are an important performance optimization in Postgres, that makes updates much more efficient. However, they are only possible if the columns being updated are not indexed (= the update is "HOT capable"). If you want to do a deep dive, we talked more about the benefits of HOT updates in Episodes 72, 40 and 14 of 5mins of Postgres.
To help you optimize your workload and index choices for HOT updates,you can now quickly see which columns are indexed on the "Columns" page for each table. This also considers columns indirectly referenced through an expression, a partial index, or in the INCLUDE part of a covering index. On the columns page you can also see how many updates each column receives per minute, and whether these updates are HOT capable.
This assessment is also done for each index recommendation considered by pganalyze Index Advisor as part of the new constraint programming model - more news on that in next month's newsletter!
đź“š Free eBook: Tuning Autovacuum for best Postgres performance
You might remember the launch of our pganalyze VACUUM Advisor back in July 2023. A lot of research has gone into developing this feature and in this new eBook we are sharing our learnings around the most important concepts of why and when Postgres has to vacuum, why that matters, and when it’s best to tune the default settings that control autovacuum scheduling, vacuum overhead, and more. In the book, we provide actionable tuning tips you can use in your specific setup.
When we initially started publishing our 5mins of Postgres videos, our goal was to share a quick, bite-sized video about recent Postgres topics once a week with the wider community.
We've been surprised and are excited about how well this weekly series has been received! Today, we have over 3,000 subscribers on our YouTube channel and are happy to be interacting with so many of you directly there. In case you missed it, we also started uploading our webinar recordings to this channel - so feel free to subscribe and check out our videos!
Looking back, some of our favorites among the first 100 episodes are:
We talk about partitioning Postgres tables by timestamp based UUIDs. We're also going to talk about the status of UUIDv7 in the current Postgres development branch.
We show how to go about finding the source of a locking problem in Postgres. Specifically, we are looking at how to debug heavyweight locks, how to end a process that’s holding a lock in Postgres, and general helpful settings for handling Postgres locking.
We take a look at how column ordering affects storage size, how you can play column tetris to optimize it, and the big benefits that array-based storage can yield for some workloads.
Subscribe on YouTube
We publish weekly videos on Postgres, our conference talks, tutorials, product walk-throughs, and more.
