pg_reindex

Usage

1. Create new indexes with the new version in the name, without alter the index and locking on the table

Delete all old unused indexes from the previous script start, which was not earlier than one hour ago

2. Create new indexes with preservation of old names, but with alter the index and locking on the table

Delete all old unused indexes from the previous script start, which was not earlier than one hour ago

3. Create new indexes with the new version in the name, without alter the index and locking on the table and deleting old indexes after creating new ones

4. Create new indexes with preservation of old names, but with alter the index and locking on the table and deleting old indexes after creating new ones

5. Create a new primary key on a table with a table lock

6. Create a new index with a table lock and delete the old index after creating a new one

7. Create new indexes for the tables specified in the schema and deleting old indexes after creating new ones

8. Print only statistics and queries, without affecting any data and without using the statistics of the bloat

Info

Author

License