Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Btree indexes, large numbers and <= comparisons
Date
Msg-id 460BBA8F.7080408@cox.net
Whole thread Raw
In response to Re: Btree indexes, large numbers and <= comparisons  ("Alejandro D. Burne" <alejandro.dburne@gmail.com>)
Responses Re: Btree indexes, large numbers and <= comparisons  (Toke Høiland-Jørgensen <toke@toke.dk>)
List pgsql-general
Tree view 
-----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@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.

- --
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-----

pgsql-general by date:

Previous
From: "Carlos H. Reimer"
Date:
Subject: RES: Order by behaviour
Next
From: Howard Cole
Date:
Subject: Re: pgAgent Crash on WinXP