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? Cheers Phil On Wednesday 17 December 2008 13:02:21 Grzegorz Jaśkiewicz wrote: > On Wed, Dec 17, 2008 at 12:55 AM, Phillip Berry > > <pbe...@stellaconcepts.com> wrote: > > I thought 185K was pretty high, is going to 700K+ reasonable? I've got > > 16GB of ram and am running very high volume 100GB+ DBs. > > all depends on how often does the data change. I would go with > whatever vacuum is suggesting on production :) > in 8.4 you won't have to worry about it anymore anyway ;) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
