From: Baptiste LHOSTE <blhoste@alaloop.com>
To: Kevin Grittner <kgrittn@mail.com>
Cc: pgsql-admin@postgresql.org, Sylvain CAILLET <scaillet@alaloop.com>
Subject: Re: Autovacuum issues with truncate and create index ...
Date: Thu, 20 Dec 2012 18:08:43 +0100 (CET)
Message-ID: <74151148.2709769.1356023323230.JavaMail.root@alaloop.com> (raw)
In-Reply-To: <20121220164208.14700@gmx.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
> Was the blocking you described occurring at the time you captured
> this? It doesn't seem to be showing any problem.
Yes indeed. We have noticed that any process seems to be in waiting situation but :
- before the autovacuum process starts to work on the both kind of tables, truncate and index creation take less than 2 seconds
- after the autovacuum process starts to work on the both kind of tables, truncate and index creation never end
We have to stop our process, then reset the autovacuum thresold for second kind of tables, then restart our process.
Is it possible that the fact that statistics of postgresql are not up-to-date could explain this behavior ?
Is it possible that the autovacuum process does not stop itself when we perform a truncate or a create index ?
> A minor release (where the version number doesn't change before the
> second dot) never requires a dump and restore. There is sometimes a
> need to do some cleanup work; for example, if a bug is fixed which
> could corrupt a particular type of index, the release notes may
> recommend rebuilding all indexes of that type to repair any damage
> which may have occurred before the bug was fixed.
As we mention in the previous mail, we can only upgrade to the 8.4.13 with Debian.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: blhoste@alaloop.com, kgrittn@mail.com, scaillet@alaloop.com
Subject: Re: Autovacuum issues with truncate and create index ...
In-Reply-To: <74151148.2709769.1356023323230.JavaMail.root@alaloop.com>
* 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