Mastering PostgreSQL 12 - Third Edition

Adding additional indexes

Since PostgreSQL 9.6, there has been an easy way to deploy entirely new index types as extensions. This is pretty cool because if those index types provided by PostgreSQL are not enough, it is possible to add additional ones that serve your purpose. The instruction to do this is CREATE ACCESS METHOD:

test=# \h CREATE ACCESS METHOD Command: CREATE ACCESS METHOD Description: define a new access method Syntax:CREATE ACCESS METHOD name     TYPE access_method_type     HANDLER handler_function URL: https://www.postgresql.org/docs/12/sql-create-access-method.html

Don't worry too much about this command—if you ever deploy your own index type, it will come as a ready-to-use extension.

One of these extensions implements bloom filters. ...