Phillip Berry <pberry@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!