Re: VACUUM VERBOSE 8.1dev

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


>>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 ...
>
>
You are absolutely (as usual) correct. Thank you. I was just
writing a retraction as I read your post.

Sincerely,

Josuha D. Drake

> regards, tom lane
>
>

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-09-14 05:37:51 Re: 8.1 system info / admin functions
Previous Message Tom Lane 2005-09-14 03:59:22 Re: VACUUM VERBOSE 8.1dev