Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM ANALYZE blocking both reads and writes to a table - Mailing list pgsql-performance

From Peter Schuller
Subject Re: VACUUM ANALYZE blocking both reads and writes to a table
Date
Msg-id 20080701152634.GA61808@hyperion.scode.org
Whole thread Raw
In response to Re: VACUUM ANALYZE blocking both reads and writes to a table  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
Tree view 
> > (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
Attachment

pgsql-performance by date:

Previous
From: Franck Routier
Date:
Subject: Re: Does max size of varchar influence index size
Next
From: Richard Huxton
Date:
Subject: Re: Does max size of varchar influence index size