Re: [GENERAL] Vacuum verbose output?

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: [GENERAL] Vacuum verbose output?
Дата
Msg-id 91aa2vo2d1pa257um4p82n84pt6i5nn5de@4ax.com
обсуждение исходный текст
Список pgsql-hackers
On 14 Jan 2003 10:54:29 -0500, Robert Treat
<xzilla@users.sourceforge.net> wrote:
>Changed = the number of pages that had to be modified.

This counts only pages changed due to heap tuple header updates
(FrozenTransactionId, hint bits).  It does not count page changes due
to removal of dead tuples, cf. Julian's log:

| NOTICE:  Pages 342: Changed 0, Empty 0; Tup 8325: Vac 838, Keep 0, UnUsed 5614.
| [...]
| NOTICE:  Pages 361: Changed 0, Empty 0; Tup 8229: Vac 1111, Keep 0, UnUsed 5981.

I don't know whether this is intentional or just an oversight.  If it
is the latter, let me know and I'll send a patch.

Servus
 Manfred

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Anyone have a fresh Solaris 8 SPARC system to create
Следующее
От: Justin Clift
Дата:
Сообщение: Re: Anyone have a fresh Solaris 8 SPARC system to create