Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page

From: "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, herouth(at)oumail(dot)openu(dot)ac(dot)il, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page
Date: 1998-02-04 02:14:09
Message-ID: 34D7CEF1.719697C8@sable.krasnoyarsk.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Keith Parks 1998-02-04 02:15:19 Re: [HACKERS] regression test "strings" failure.
Previous Message Thomas G. Lockhart 1998-02-04 01:27:10 Re: [HACKERS] regression test "strings" failure.