Hacker News new | ask | show | jobs
by watt 779 days ago
Could you also mention what is the appropriate way to go about it?
1 comments
keeperofdakeys 779 days ago
Either put machinery in your schema migration tool to create indexes as a separate step, so they are easy to re-apply. This makes keeping indexes in sync between production and staging a lot easier. Or you can use "CREATE TABLE_B (LIKE TABLE_A WITH INDEXES);".
link
kroolik 778 days ago
Make sure to create indices AFTER the data is in. Its way faster to create indices from data than create them empty and insert data.

Also make sure to set maintenance_work_mem high as it helps with index creation

link