Re: Continual Postgres headaches...

On Thursday 06 December 2007 20:00, Tom Lane wrote:
> "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.
>

just to add, make sure your free_space_map settings are set adequately;
otherwise you might not be able to find an adequate schedule.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL