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 <[EMAIL PROTECTED]>: > > [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. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly