Re: max_fsm_pages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar>
Cc: ryan(at)paymentalliance(dot)net, pgsql-general(at)postgresql(dot)org
Subject: Re: max_fsm_pages
Date: 2003-12-08 17:14:53
Message-ID: 18867.1070903693@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar> writes:
> sapiens=3D# vacuum verbose;
> ...
> INFO: free space map: 1 relations, 39 pages stored; 48 total pages
> needed

Apparently this is a freshly loaded database that you've not made many
changes in yet?

I'd recommend waiting till you've had some level of normal update
activity before trying to discover an optimal size for FSM ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Keith C. Perry 2003-12-08 17:24:31 Re: pgsql 7.4 on minimal environment
Previous Message Domagoj Čajić 2003-12-08 17:12:06 remove