"Allgood, John" wrote:
> What exactly am I looking for
> INFO: free space map contains 2667 pages in 22 relations
> DETAIL: A total of 3008 page slots are in use (including overhead).
> 3008 page slots are required to track all free space.
> Current limits are: 153600 page slots, 1000 relat
Hello Again
Here is the end output from a vacuum verbose on one of the databases. What
exactly am I looking for. If I am reading the correctly then I am ok with the
current settings.
INFO: free space map contains 2667 pages in 22 relations
DETAIL: A total of 3008 page slots are in use (includ
Run a vacuum verbose and look at the output at the end.
Word is that as of 8.4 these parameters will autotune themselvs.
--- On Wed, 24/6/09, Allgood, John wrote:
> From: Allgood, John
> Subject: Re: [ADMIN] tuning our database by increasing shared buffer
> To: "Barbara Stephenson" , "Tom Lan
Hello All
I am working with Barbara on this project and I am curios about what
would be a good starting place for setting the max_fsm_relations and
max_fsm_pages. Here are the current values max_fsm_pages = 153600 and
the max_fsm_relations is set to the default of 1000. I have have read
that t
