Re: UPDATES hang every 5 minutes - Mailing list pgsql-general

From Tom Lane
Subject Re: UPDATES hang every 5 minutes
Date
Msg-id 5074.1186704912@sss.pgh.pa.us
Whole thread Raw
In response to Re: UPDATES hang every 5 minutes  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
Greg Smith <gsmith@gregsmith.com> 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

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: UPDATES hang every 5 minutes
Next
From: Steve Madsen
Date:
Subject: Re: Interpreting statistics collector output