Re: [GENERAL] Vacuum verbose output? - Mailing list pgsql-hackers

From Manfred Koizar
Subject Re: [GENERAL] Vacuum verbose output?
Date
Msg-id 91aa2vo2d1pa257um4p82n84pt6i5nn5de@4ax.com
Whole thread Raw
List 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 by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Anyone have a fresh Solaris 8 SPARC system to create
Next
From: Justin Clift
Date:
Subject: Re: Anyone have a fresh Solaris 8 SPARC system to create