Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page\ - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page\
Date
Msg-id 199802040237.VAA01873@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page  ("Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>)
List pgsql-hackers
>
> The Hermit Hacker wrote:
> >
> >         So, why is pg_class locked for the duration of a vacuum when the
> > vacuum is being performed for the whole database when it should (I think)
> > only need to be locked when updates are happening to it?
>
> Yes, this is how it should be. This long lock comes from very old time.
> When I visited vacuum last time (year ago) I hadn't time to decide
> why this lock is here and could it be just removed or not.
> Still no time :)
>
> Vadim
>
>

Added to TODO:

    * Make VACUUM on database not lock pg_class
    * Make VACUUM ANALYZE only use a readlock




--
Bruce Momjian
maillist@candle.pha.pa.us

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [QUESTIONS] timestamp questions
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page\