Re: Btree indexes, large numbers and <= comparisons

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Btree indexes, large numbers and <= comparisons
Date: 2007-03-29 13:09:35
Message-ID: 460BBA8F.7080408@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD4DBQFGC7qOS9HxQb37XmcRAl8eAKDeMRvbTR8gjHgf2RugrELXffQCVQCWM8co
zySEdLt3JYKAkFMa6oywOw==
=Rg8p
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Howard Cole 2007-03-29 13:24:32 Re: pgAgent Crash on WinXP
Previous Message Carlos H. Reimer 2007-03-29 12:32:50 RES: Order by behaviour