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/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match