Re: BUG #5722: vacuum full does not update last_vacuum statistics

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: BUG #5722: vacuum full does not update last_vacuum statistics
Дата
Msg-id AANLkTi=ygM2C_DWz9iH6fseyjF6mfbZHoTzjVHt_so1N@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #5722: vacuum full does not update last_vacuum statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #5722: vacuum full does not update last_vacuum statistics
Список pgsql-bugs
On Mon, Oct 25, 2010 at 8:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Perhaps. =A0The new implementation of VACUUM FULL is really more like a
> CLUSTER, or one of the rewriting variants of ALTER TABLE. =A0Should all
> of those operations result in an update of last_vacuum? =A0From an
> implementation standpoint it's difficult to say that only some of them
> should, because all of them result in a table that has no immediate
> need for vacuuming. =A0The only argument I can see for having only VACUUM
> FULL update the timestamp is that it's called VACUUM and the others
> aren't. =A0Which is an argument, but not a terribly impressive one IMO.

Perhaps we should have another field last_table_rewrite or something?


--=20
greg

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Segfault in 9.0 inlining SRF
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: BUG #5722: vacuum full does not update last_vacuum statistics