On Thursday 29 March 2007 15:09, Ron Johnson wrote: > On 03/29/07 06:33, Alejandro D. Burne wrote: > > 2007/3/29, Toke Høiland-Jørgensen <toke@xxxxxxx>: > > [snip] > > >> Any help will be greatly appreciated. > >> > >> Regards, > >> -Toke > > > > Can you send an explain analyze for that query? > > And tell us how often you VACCUM & which version of PG you are running. Ah, yes, sorry...forgot about that. I've tried running both VACUUM ANALYSE and REINDEX to no avail. Postgresql v. 7.4.16.
