Re: Btree indexes, large numbers and <= comparisons

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Btree indexes, large numbers and <= comparisons
Дата
Msg-id 460BBA8F.7080408@cox.net
обсуждение исходный текст
Ответ на Re: Btree indexes, large numbers and <= comparisons  ("Alejandro D. Burne" <alejandro.dburne@gmail.com>)
Ответы Re: Btree indexes, large numbers and <= comparisons  (Toke Høiland-Jørgensen <toke@toke.dk>)
Список 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@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 по дате отправления:

Предыдущее
От: "Carlos H. Reimer"
Дата:
Сообщение: RES: Order by behaviour
Следующее
От: Howard Cole
Дата:
Сообщение: Re: pgAgent Crash on WinXP