On Wed, Dec 17, 2008 at 2:29 AM, Phillip Berry <pbe...@stellaconcepts.com> wrote: > > The data in nearly every table is constantly changing due to a high volume of > new data constantly > coming in, processing on the existing data and heavy reporting being done all > at once all day and > night. > > So I guess my question is, is there a point where you start to see > diminishing returns or even > negative returns by setting the fsm too high?
I personally didn't experience anything like that. If the data is updated, but not deleted mostly - you should do something to utilize HOT (if using 8.3). Otherwise, you want FSM to be big enough - so that more and more deleted records could get reused without need for so often vacuum. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
