From: Peter Schuller <peter.schuller@infidyne.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: VACUUM ANALYZE blocking both reads and writes to a table
Date: Mon, 30 Jun 2008 17:34:35 +0200
Message-ID: <20080630153435.GA15756@hyperion.scode.org> (raw)
In-Reply-To: <20080630152515.GF10311@alvh.no-ip.org>
References: <20080630145903.GA15197@hyperion.scode.org>
<20080630152515.GF10311@alvh.no-ip.org>
Hello,
> No. VACUUM takes an exclusive lock at the end of the operation to
> truncate empty pages. (If it cannot get the lock then it'll just skip
> this step.) In 8.2.4 there was a bug that caused it to sleep
> according to vacuum_delay during the scan to identify possibly empty
> pages. This was fixed in 8.2.5:
[snip revision log]
Thank you very much! This does indeed seem to be the likely
culprit. Will try to either upgrade, or if not possible in time for
the next occurance, confirm that this is what is happening based on
pg_locks.
Thanks again for the very informative response.
--
/ Peter Schuller
PGP userID: 0xE9758B7D or 'Peter Schuller <peter.schuller@infidyne.com>'
Key retrieval: Send an E-Mail to getpgpkey@scode.org
E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org
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: peter.schuller@infidyne.com, alvherre@commandprompt.com
Subject: Re: VACUUM ANALYZE blocking both reads and writes to a table
In-Reply-To: <20080630153435.GA15756@hyperion.scode.org>
* 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