Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovaccum and Full vacuum - Mailing list pgsql-novice

From Tony Day
Subject Re: Autovaccum and Full vacuum
Date
Msg-id r2l22eb2d871005042146r94863236pb6fe91006bd13e04@mail.gmail.com
Whole thread Raw
In response to Autovaccum and Full vacuum  (Tony Day <tonyd@panztel.com>)
Responses Re: Autovaccum and Full vacuum  (Shoaib Mir <shoaibmir@gmail.com>)
List pgsql-novice
Tree view
Hi Shoaib

Thanks for the response.

Sorry - I forgot to mention that I am using PostgreSQL 8.3.9 on Ubuntu 9.04.
And just to be clear - I am not suggesting that there is a bug in Postgresql :-)
I am just trying to clarify what it does and doesn't do.

Regards, Tony




On Wed, May 5, 2010 at 4:34 PM, Shoaib Mir <shoaibmir@gmail.com> wrote:
On Wed, May 5, 2010 at 2:28 PM, Tony Day <tonyd@panztel.com> wrote:

I guess what I would really like to know is - is it possible that autovacuum will request a AccessExclusiveLock and if yes, under what circumstances?




IIRC, there was a similar bug in pre 8.3. Which version are you using?

--
Shoaib Mir
http://shoaibmir.wordpress.com/

pgsql-novice by date:

Previous
From: Shoaib Mir
Date:
Subject: Re: Autovaccum and Full vacuum
Next
From: Shoaib Mir
Date:
Subject: Re: Autovaccum and Full vacuum