Re: Btree indexes, large numbers and <= comparisons

From: Toke Høiland-Jørgensen <toke(at)toke(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Btree indexes, large numbers and <= comparisons
Date: 2007-03-29 13:47:28
Message-ID: 200703291547.28501.toke@toke.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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>:
>
> [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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-03-29 13:51:27 Re: RES: Order by behaviour
Previous Message Toke Høiland-Jørgensen 2007-03-29 13:33:15 Re: Btree indexes, large numbers and <= comparisons