Re: sequence query performance issues

Поиск
Список
Период
Сортировка
От Peter Koczan
Тема Re: sequence query performance issues
Дата
Msg-id 4544e0330709281033s5a8c72ccj979f1c02a43188a0@mail.gmail.com
обсуждение исходный текст
Ответ на Re: sequence query performance issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: sequence query performance issues
Список pgsql-performance
> > Hmm - why is it doing that?
>
> I'm betting that the OP's people.uid column is not an integer.  Existing
> PG releases can't use hashed subplans for cross-data-type comparisons
> (8.3 will be a bit smarter).

*light bulb* Ahhhhhhh, that's it. So, I guess the solution is either
to cast the column or wait for 8.3 (which isn't a problem since the
port won't be done until 8.3 is released anyway).

Thanks again.

Peter

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Postgres 7.4.2 hanging when vacuum full is run
Следующее
От: Arctic Toucan
Дата:
Сообщение: OOM Errors as a result of table inheritance and a bad plan(?)