Steve Poe <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly