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
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 |