Phillip Berry <pbe...@stellaconcepts.com> writes: > 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?
There is no benefit to having FSM larger than necessary, so I suppose that qualifies as "diminishing returns". The only negative effect is the reduced memory available for caches and shared buffers. You might also want to check that you don't have just a few tables which have a lot of dead space in them. If so filling the FSM is the least of your worries. The tables with lots of dead space will perform poorly because of the time spent sifting through all that dead space. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
