Steve Poe <spoe@sfnet.cc> writes:
> Try enabliing your checkpoint_segments. In my example, our database
> restore took 75mins. After enabling checkpoints_segments to 20, we cut
> it down to less than 30 minutes.
Increasing maintenance_work_mem might help too ... or several other
settings ... with no information about exactly *what* is slow, it's
hard to say.
regards, tom lane