#371 — September 2, 2020

Web Version

Postgres Weekly

An Overview of Trusted Extensions in PostgreSQL 13 — Postgres supports extensions as a way to easily introduce new features and functions dynamically, but in Postgres 13 there’ll be the concept of a trusted extension which will allow any user with CREATE privileges on the current database to bring in an extension without superuser privileges.

Nidhi Bansal

Tuning Autovacuum for Postgres Databases — Most of the time you don’t need to tweak the settings for autovacuum as Postgres will generally do the right thing, but sometimes the default configuration just isn’t enough and this article will help you with some approaches for tuning things.

Laurenz Albe

Best-Practices on How to Speed Up Your Postgres Queries. Free eBook — Companies like Robinhood and Atlassian are able to speed up their queries by orders of magnitude. This eBook shares our best practices for optimizing Postgres performance.

pganalyze sponsor

Three Easy Things To Remember About Postgres Indexes — Basic ideas, but worth reviewing if you’re not an index expert. Indexes can speed things up beyond simple queries, indexes aren’t always used even if you think they should be, and indexes add maintenance and storage overhead you need to be prepared to manage.

Kat Batuigas

Parallelism Comes to VACUUM in Postgres 13 — One of the noteworthy new features in Postgres 13 will be the ability to speed up the execution time of index vacuuming. Masahiko provides a quick example of the benefits.

Masahiko Sawada

How JSON Aggregate Functions Are Pretty Cool — Rather than extract data with SQL queries and then convert it into JSON, you could get Postgres to do the heavy lifting instead and here’s how.

Knut Hühne

The Need for External Compression Methods in Postgres — If you could specify different compression systems for different tables or columns, based upon the most appropriate one for the type of data stored, that would be pretty neat.. and it seems the Postgres team are beginning to discuss such a potential feature in Postgres.

Amit Khandekar

Using Envoy Proxy’s New PostgreSQL & TCP Filters to Collect SQL Statistics — The new PostgreSQL filter from Envoy Proxy makes it easy for developers and ops engineers to collect SQL statistics.

YugabyteDB sponsor

Benchmarking Checkpointing in Postgres — Evaluating checkpointing with varying log sizes from 1GB to 100GB.

Vadim Tkachenko

Full-Text Search Battle: Postgres vs Elasticsearch — Less a battle and more a basic comparison of techniques with a simple benchmark, but may be of interest.

Rocky Warren

Pitfalls and Quirks of Logical Replication in Postgres 12“I’d like to share some thoughts after setting up a logical replication in a large-ish (one terabyte) production database.”

Elephant Tamer