max_fsm_pages - Mailing list pgsql-general

From Ryan Mahoney
Subject max_fsm_pages
Date
Msg-id 1070638448.8567.24.camel@localhost.localdomain
Whole thread Raw
Responses Re: max_fsm_pages  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
When interactively calculating the ideal value for max_fsm_pages by
summarizing the output of VACUUM VERBOSE, which statistic from vacuum am
I concerned with?

We've got a database that takes about 5 hours to VACUUM FULL and
prevents the server from doing anything useful during that time.
Currently it is scheduled to run twice weekly, but I would like to start
using the auto vacuum daemon instead.

Thanks!

-r


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: update time zone in timestamps
Next
From: "Jennifer Lee"
Date:
Subject: Re: function to find last day of month