Skip site navigation (1) Skip section navigation (2)

Re: Autovaccum and Full vacuum

From: Tony Day <tonyd(at)panztel(dot)com>
To: Shoaib Mir <shoaibmir(at)gmail(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Autovaccum and Full vacuum
Date: 2010-05-05 04:46:31
Message-ID: r2l22eb2d871005042146r94863236pb6fe91006bd13e04@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)gmail(dot)com> wrote:

> On Wed, May 5, 2010 at 2:28 PM, Tony Day <tonyd(at)panztel(dot)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/
>

In response to

Responses

pgsql-novice by date

Next:From: Shoaib MirDate: 2010-05-05 05:01:04
Subject: Re: Autovaccum and Full vacuum
Previous:From: Shoaib MirDate: 2010-05-05 04:34:23
Subject: Re: Autovaccum and Full vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group