Re: Vacuum explained

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: Vacuum explained
Дата
Msg-id 1041884632.15455.112.camel@camel
обсуждение исходный текст
Ответ на Vacuum explained  ("Gaetano Mendola" <mendola@bigfoot.com>)
Ответы Re: Vacuum explained  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
This is a rough description, should anyone see a need to correct it
please do so.

On Sat, 2003-01-04 at 09:42, Gaetano Mendola wrote:
> NOTICE:  Pages 2518: Changed 38, Empty 0; Tup 75489: Vac 447, Keep 68661,
> UnUsed 144574.
>         Total CPU 1.31s/0.25u sec elapsed 48.23 sec.

Pages = the # of pages being used to store your data.

Changed = the # of pages that have been modified as a result of your
most recent vacuum.

Empty = pages containing no "live" tuples

Tup = # of "rows" in your table

Vac = # of dead tuples recovered

Keep = # of tuples that the db did not feel it could safely mark/remove
(probably envolved in some type of transaction)

Unused = # of tuples awaiting being reused

elapsed time is the amount of time it took to deal with the given table

Robert Treat



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: restore/dup OIDs HELP!
Следующее
От: Robert Treat
Дата:
Сообщение: Re: Get client's IP