Re: Postgresql works too slow - Mailing list pgsql-performance

From Tom Lane
Subject Re: Postgresql works too slow
Date
Msg-id 14024.1113804695@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgresql works too slow  (Steve Poe <spoe@sfnet.cc>)
Responses Re: Postgresql works too slow
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Steve Poe
Date:
Subject: Re: Postgresql works too slow
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Postgresql works too slow