Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A39F364FD67 for ; Tue, 1 Jul 2008 12:27:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 74949-02-5 for ; Tue, 1 Jul 2008 12:26:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hyperion.scode.org (hyperion.scode.org [85.17.42.115]) by postgresql.org (Postfix) with ESMTP id 7329A650EF7 for ; Tue, 1 Jul 2008 12:26:38 -0300 (ADT) Received: by hyperion.scode.org (Postfix, from userid 1001) id 7048E23C49A; Tue, 1 Jul 2008 17:26:35 +0200 (CEST) Date: Tue, 1 Jul 2008 17:26:35 +0200 From: Peter Schuller To: Alvaro Herrera Cc: Tom Lane , pgsql-performance@postgresql.org Subject: Re: VACUUM ANALYZE blocking both reads and writes to a table Message-ID: <20080701152634.GA61808@hyperion.scode.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> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="TB36FDmn/VVEgNH/" Content-Disposition: inline In-Reply-To: <20080630190419.GC18252@alvh.no-ip.org> User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/7 X-Sequence-Number: 30607 --TB36FDmn/VVEgNH/ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable > > (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. >=20 > 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! --=20 / Peter Schuller PGP userID: 0xE9758B7D or 'Peter Schuller ' Key retrieval: Send an E-Mail to getpgpkey@scode.org E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org --TB36FDmn/VVEgNH/ Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (FreeBSD) iEYEARECAAYFAkhqTKoACgkQDNor2+l1i31FLQCggrWIPcz//0GOTloduCJHC0d/ yx0AniQ0aQowbJeCbc38UEGnMz9QoshD =D9Jd -----END PGP SIGNATURE----- --TB36FDmn/VVEgNH/--