Hi there,

Welcome to the October 2022 issue of the pganalyze newsletter!

This is our first issue with the updated newsletter layout - thanks to everyone who gave us feedback on which styling and layout you prefer.

Our team has been busy working on new VACUUM monitoring and tuning recommendation features in pganalyze (more on that soon), improvements to the Index Advisor and more. We've also launched 🔒 Lock Monitoring in early access - let us know if you want to try it out!

We're happy to share some of what we've learned about VACUUM in our upcoming webinar on autovacuum tuning on November 16th, at 9:30am Pacific.

As always, you can also find our 5mins of Postgres episodes in the newsletter, where we've talked about topics such as BRIN indexes, shared_buffers tuning and more.

All the best,

Lukas

Webinar on Nov. 16th, 9:30am Pacific Time: How to tune Postgres autovacuum to improve performance and reduce bloat →

In our upcoming webinar we’ll show you how to tune your Postgres autovacuum settings to ensure that VACUUM runs at the right time, and is effective for your workload.

We’ll also talk about the two main goals of VACUUM: Preventing table bloat and avoiding Transaction ID and MultiXact wraparound. See a more detailed agenda of the webinar on our landing page!

5mins of Postgres

E37: New in Postgres 15: Logical replication column filters & database-wide ICU collations→

We talk discuss new features in Postgres 15, including logical replication improvements and database wide ICU locales.

E38: When to use BRIN indexes in Postgres, tuning pages_per_range and determining correlation with pg_stats→

We talk about tuning a Postgres BRIN index and how to decide whether to use BRIN based on pg_stats statistics and the correlation column. We also talk about the impact block ranges can have and a visual model on how to think about BRIN indexes.

E39: Postgres 15 release, and 6 tips for managing indexes→

We walk through the Postgres 15 release, and six findings to improve how you manage your Postgres indexes.

E40: How to debug slow Postgres UPDATEs and bloated tables with auto_explain & page_inspect→

We talk about why Postgres UPDATEs are getting slower over time, HOT updates, auto_explain, the pageinspect extension, and reasons why VACUUM won’t remove dead rows from a table.

E41: Tuning shared_buffers for OLTP and data warehouse workloads & is 25% of RAM a good choice?→

We talk about tuning shared_buffers, benchmarking with pgbench, TPROC-C and TPROC-H, and whether using 25% of RAM is a good choice.

Subscribe on YouTube

We publish weekly videos on Postgres, our conference talks, tutorials, product walk-throughs, and more.

Product updates

Review us on G2

Please leave your feedback (good or bad!) in this survey - we appreciate it!