Making use of contrib modules

Now that we have had a look at a theoretical introduction to extensions, it is time to take a look at some of the most important extensions. In this section, you will learn about modules that are provided to you as part of the PostgreSQL contrib module. When you install PostgreSQL, I recommend that you always install these contrib modules, as they contain vital extensions that can really make your life easier.

In the upcoming section, we will walk you through some extensions that I find the most interesting and the most useful for a variety of reasons (for debugging, performance tuning, and so on).

Applying bloom filters

Since PostgreSQL 9.6, it has been possible to add index types on the fly using extensions. The new CREATE ACCESS METHOD command, along with some additional features, has made it possible for us to create fully functional and transaction-logged index types on the fly.

The bloom extension provides PostgreSQL users with bloom...