Re: perf pb solved only after pg_dump and restore

Markus Schaber <schabi 'at' logix-tt.com> writes:

> > VACUUM ANALYZE is normally run overnight (each night). Is it not
> > regular enough? There can be hundreds of thousands of statements
> > a day.
>
> Which PostgreSQL version are you using? Maybe you should consider
> autovacuum (which is a contrib module at least since 7.4, and included
> in the server since 8.1). If you think that vacuum during working hours
> puts too much load on your server, there are options to tweak that, at
> least in 8.1.

Ok, thanks. Unfortunately production insists on sticking on 7.4.5
for the moment :/

--
Guillaume Cottenceau
Create your personal SMS or WAP Service - visit http://mobilefriends.ch/