Re: Question on output of VACUUM VERBOSE

["Thomas F.O'Connell" <tfo@xxxxxxxxxxxx>]

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


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match