Why are the primary keys created after the other indexes? That means that the table data had been evicted from the cache and has to be reloaded.
What is stored in the index files? Why do they take so long to create, and why do they take up 50% of the space of the tables themselves?
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
