Postgres Pro
Downloads
Home   >   mailing lists

Re: Btree indexes, large numbers and <= comparisons - Mailing list pgsql-general

From Toke Høiland-Jørgensen
Subject Re: Btree indexes, large numbers and <= comparisons
Date
Msg-id 200703291547.28501.toke@toke.dk
Whole thread Raw
In response to Re: Btree indexes, large numbers and <= comparisons  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Tree view 
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@toke.dk>:
>
> [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.

pgsql-general by date:

Previous
From: Toke Høiland-Jørgensen
Date:
Subject: Re: Btree indexes, large numbers and <= comparisons
Next
From: Richard Huxton
Date:
Subject: Re: RES: Order by behaviour