From: Craig Ringer <craig@postnewspapers.com.au>
To: Junghwe Kim <junghwe.kim76@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Is any effect other process performance after vaccumdb finished ?
Date: Fri, 27 May 2011 11:31:59 +0800
Message-ID: <4DDF1B2F.4050708@postnewspapers.com.au> (raw)
In-Reply-To: <BANLkTim+aE27feMk8xu4MX3z0bcxNkmxvA@mail.gmail.com>
References: <BANLkTim+aE27feMk8xu4MX3z0bcxNkmxvA@mail.gmail.com>
On 27/05/2011 9:58 AM, Junghwe Kim wrote:
> Hi.
>
> First extremely thanks for your works about postgresql .
>
> I wonder that after executing 'vaccumdb -z' some other process can not
> read their own msg queue during 2 ~ 3 minuts.
The most likely cause is checkpoint activity. Enable checkpoint logging
and examine your server logs.
> vaccum executed every hour. and The processes have not any relations
> between postgreql.
Instead of running vacuum from cron or some other scheduler, turn on
autovacuum and set it to run aggressively. You will reduce the impact of
vacuum if you run it *often* (every few minutes if not more frequently)
and do so using autovacuum.
Best results will be had on PostgreSQL 8.4 or above.
Please read this if you need to follow up, so you include enough
information that a more complete answer can be given:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig@postnewspapers.com.au, junghwe.kim76@gmail.com
Subject: Re: Is any effect other process performance after vaccumdb finished ?
In-Reply-To: <4DDF1B2F.4050708@postnewspapers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox