Joseph Shraibman <jks@selectacast.net> 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 CVS tip, they're created together.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
