so a while back, i think i recall a post from Bruce Momjian describing
an optimum setup for shared_buffers at 25% of available physical memory
and sort_mem at 4% of available physical memory.
the caveat was to watch for swap activity when these values were being
set. so my question is, how much swapping is too much, and is there a
way to determine whether postgres is the process causing the swapping?
hmm. maybe that's two questions?... :)
-tfo