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(at)toke(dot)dk>:
> >> 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.
In response to
pgsql-general by date
|Next:||From: Richard Huxton||Date: 2007-03-29 13:51:27|
|Subject: Re: RES: Order by behaviour|
|Previous:||From: Toke Høiland-Jørgensen||Date: 2007-03-29 13:33:15|
|Subject: Re: Btree indexes, large numbers and <= comparisons|