Vivek Khera <khera@kcilink.com> writes:
> Well, for me the create index part of the restore is what takes about
> 3x the time for the data load. Total about 4 hours. The dump takes 1
> hour.
What sort_mem do you use for the restore? Have you tried increasing it?
regards, tom lane