Vacuum now uses AccessShareLock for analyze
От | Bruce Momjian |
---|---|
Тема | Vacuum now uses AccessShareLock for analyze |
Дата | |
Msg-id | 200005291553.LAA10941@candle.pha.pa.us обсуждение исходный текст |
Ответы |
Re: Vacuum now uses AccessShareLock for analyze
Re: Vacuum now uses AccessShareLock for analyze |
Список | 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@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: