From: Simon Riggs <simon@2ndquadrant.com>
To: RESTOUX, Loïc <loic.restoux@capgemini.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [PG 8.1.0 / AIX 5.3] Vacuum processes freezing
Date: Thu, 14 Jun 2007 16:23:23 +0100
Message-ID: <1181834603.5776.66.camel@silverbirch.site> (raw)
In-Reply-To: <F10D59BC922A9D47B7FE1B0A31AC7B5343D4DB@CORPMAIL31.corp.capgemini.com>
References: <F10D59BC922A9D47B7FE1B0A31AC7B5343D4DB@CORPMAIL31.corp.capgemini.com>
On Wed, 2007-06-13 at 18:33 +0200, RESTOUX, Loïc wrote:
> 2) I believed that the poor performances during the vacuum freeze were due to the obsolete data statistics. But after a full restart of the dabatase, performances are good. Does PostgreSQL rebuild his statistics during startup ?
You probably don't need to run VACUUM FREEZE.
VACUUM FREEZE will thrash the disks much more than normal VACUUM. We're
improving that somewhat in 8.3, but the basic issue is that VACUUM
FREEZE cleans out more dead rows and so will dirty more data blocks.
Are you concurrently running DDL, Truncate or CLUSTER? That will
interfere with the operation of VACUUM.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.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: simon@2ndquadrant.com, loic.restoux@capgemini.com
Subject: Re: [PG 8.1.0 / AIX 5.3] Vacuum processes freezing
In-Reply-To: <1181834603.5776.66.camel@silverbirch.site>
* 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