| 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 |
| 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 |
| 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 |
|
