Re: Question on output of VACUUM VERBOSE

I think that INFO gives you information about your current usage and
that DETAIL tells you what is currently set in your configuration.

In this example, the default settings appear to be sufficient for your
database. If the values in INFO were larger than the values in DETAIL,
you would want to consider increasing max_fsm_relations and
max_fsm_pages in postgresql.conf.

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Jan 17, 2005, at 5:14 PM, Cornelia Boenigk wrote:

> Hi all
>
> I don't understand what these two lines exactly mean.
>
> INFO: free space map: 490 relations, 13541 pages stored; 34480 total
> pages
> needed
> DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB
> shared
> memory
>
> Thanks in advance
> Conni