Vacuum now uses AccessShareLock for analyze

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Vacuum now uses AccessShareLock for analyze
Date: 2000-05-29 15:53:46
Message-ID: 200005291553.LAA10941@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have changed vacuum so analyze now uses AccessShareLock. (Is this the
proper lock for analyze?)

The code will now vacuum all requested relations. It will then analyze
each relation. This way, all the exclusive vacuum work is done first,
then analyze can continue with shared locks.

The code is much clearer with that functionality split into separate
functions.

How separate do people want vacuum and analyze? Analyze currently does
not record the number of tuples and pages, because vacuum does that. Do
people want analyze as a separate command and in a separate file?

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-05-29 16:08:18 Additional system indexes
Previous Message Jan Wieck 2000-05-29 15:03:10 Applying TOAST to CURRENT