Re: Continual Postgres headaches...

"Weber, Geoffrey M." <Geoffrey.Weber@mcleodusa.com> writes:
> My problems really are with performance consistency.  I have tweaked the
> execution so that everything should run with sub-second execution times, but
> even after everything is running well, I can get at most a week or two of
> steady running before things start to degrade.

Aside from the other responses: gradual degradation over a period of
time sounds like a bloat problem to me.  You should monitor table and
index sizes to confirm or deny that and find out just what's bloating.
Switching to autovacuum, or a better-designed manual vacuum schedule,
might be the ultimate answer, but first you need some concrete data
about what's going wrong.  Otherwise you're just shooting in the dark.

            regards, tom lane