Joseph Shraibman <[EMAIL PROTECTED]> writes:
> I recently dumped and restored a 7.4.2 database. It took 30 minutes for
> the data to load (6 gig) and 45 for the indexes to be created (3 gig).
Increasing sort_mem might help.
> Why are the primary keys created after the other indexes?
AFAICS in
I recently dumped and restored a 7.4.2 database. It took 30 minutes for
the data to load (6 gig) and 45 for the indexes to be created (3 gig).
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
