Re: VACUUM VERBOSE 8.1dev

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: VACUUM VERBOSE 8.1dev
Date: 2005-09-14 03:59:22
Message-ID: 29003.1126670362@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> It seems the new VACUUM VERBOSE output is not quite as helpful as 8.0.
> In 8.0 I get a nice output at the end like this:

> INFO: free space map: 1377 relations, 22478 pages stored; 44112 total
> pages needed
> DETAIL: Allocated FSM size: 100000 relations + 2000000 pages = 17702 kB
> shared memory.

AFAIR, in both 8.0 and 8.1 that info appears only at the end of a
database-wide vacuum. Your example is a single-table vacuum, which
certainly doesn't show that info in 8.0 ...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2005-09-14 04:03:27 Re: VACUUM VERBOSE 8.1dev
Previous Message Joshua D. Drake 2005-09-14 03:44:44 VACUUM VERBOSE 8.1dev