On Wed, Dec 17, 2008 at 2:29 AM, Phillip Berry <pberry@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
