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

Reply via email to