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/
