isgasho / pg_parallizator Goto Github PK

This extension can reduce time of loading data in database by building indexes in parallel. It launches new backend for execution of "CREATE INDEX" statement. Maximal number of concurrently constructed indexes is limited by "pg_parallizator.max_workers" parameter (default value is 8). When this limit is reached, current backends waits completion of most recently started index creation. Also backend waits completion of all started workers before exit.

pg_parallizator establishes local connection to the database, so such access should be enabled.

pg_parallizator run in parallel only explicitly created indexes (not one created implicitly during table creation, such as primary key index). Also indexes created with CONCURRENTLY qualifier are not considered (because building them in parallel may cause deadlock).

To use pg_parallizator please load correspondent library using the following command:

LOAD 'pg_parallizator';