Hacker News new | ask | show | jobs
by kroolik 777 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