I have a 200 GB database with 26 tables that I need to create indexes on.
Currently index creation takes a long time on the biggest tables, as they have ~12gb and 400,000,000 rows in them (>4 hours).
maintenance_work_mem to 100gb, and set
max_parallel_workers to 30.
Are there any other parameters I should tune to improve the index creation speed?
This is on AWS Aurora, using postgres-10.6, in case that makes a difference.
There is no one else using the database and downtime/full locks are fine.