Re: Btree indexes, large numbers and <= comparisons

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

Предыдущее
От: Toke Høiland-Jørgensen
Дата:
Сообщение: Re: Btree indexes, large numbers and <= comparisons
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: RES: Order by behaviour