| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, Julian Scarfe <julian(dot)scarfe(at)ntlworld(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Vacuum verbose output? |
| Date: | 2003-01-15 09:42:41 |
| Message-ID: | 91aa2vo2d1pa257um4p82n84pt6i5nn5de@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On 14 Jan 2003 10:54:29 -0500, Robert Treat
<xzilla(at)users(dot)sourceforge(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dev | 2003-01-15 10:02:57 | Re: Wrong query execution. |
| Previous Message | frbn | 2003-01-15 08:14:06 | (no subject) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2003-01-15 14:20:53 | Re: Anyone have a fresh Solaris 8 SPARC system to create |
| Previous Message | Viacheslav N Tararin | 2003-01-15 09:33:31 | WIn32 port |