From: Peter Schuller <peter.schuller@infidyne.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: VACUUM ANALYZE blocking both reads and writes to a table
Date: Tue, 1 Jul 2008 17:26:35 +0200
Message-ID: <20080701152634.GA61808@hyperion.scode.org> (raw)
In-Reply-To: <20080630190419.GC18252@alvh.no-ip.org>
References: <20080630145903.GA15197@hyperion.scode.org>
<20080630152515.GF10311@alvh.no-ip.org>
<20080630154318.GB15756@hyperion.scode.org>
<20080630162306.GA18252@alvh.no-ip.org>
<3064.1214852440@sss.pgh.pa.us>
<20080630190419.GC18252@alvh.no-ip.org>
> > (2) If it's autovacuum we're talking about, it will get kicked off the
> > table if anyone else comes along and wants a conflicting lock.
>
> Not on 8.2 though.
That is also nice to know. One more reason to upgrade to 8.3.
Thank you very much, both Alvaro and Tom, for the very insightful
discussion!
--
/ 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, tgl@sss.pgh.pa.us
Subject: Re: VACUUM ANALYZE blocking both reads and writes to a table
In-Reply-To: <20080701152634.GA61808@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