Greg Smith <gsmith@xxxxxxxxxxxxx> writes:
> Try increasing checkpoint_warning in your postgresql.conf file to its
> maximum of 3600 and restart the server when you can tolerate a small
> service disruption;
You don't need a server restart to change checkpoint_warning --- SIGHUP
("pg_ctl reload") should be enough.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
