"Weber, Geoffrey M." <Geoffrey.Weber@xxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
