Re: Vacuum explained

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum explained
Дата
Msg-id 26423.1041885959@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Vacuum explained  (Robert Treat <xzilla@users.sourceforge.net>)
Ответы Re: Vacuum explained  (Tilo Schwarz <mail@tilo-schwarz.de>)
Список pgsql-admin
Robert Treat <xzilla@users.sourceforge.net> writes:
> Tup = # of "rows" in your table

Right.  This is the number of rows remaining after the vacuum, to be
precise.

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

More specifically, these are tuples that are committed dead, but cannot
yet be removed because they might still be visible under the MVCC rules
to one or more open transactions.  This number is included in "Tup".

> Unused = # of tuples awaiting being reused

These are not actually tuples, but tuple slots (page item pointers)
that are open for re-use.

            regards, tom lane

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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: Get client's IP
Следующее
От: Jeff Boes
Дата:
Сообщение: ANALYZE not working?