Re: Is indexing broken for bigint columns?

Поиск
Список
Период
Сортировка
От Mike Mascari
Тема Re: Is indexing broken for bigint columns?
Дата
Msg-id 403BDDAC.4000706@mascari.com
обсуждение исходный текст
Ответ на Is indexing broken for bigint columns?  ("Dann Corbit" <DCorbit@connx.com>)
Список pgsql-hackers
Dann Corbit wrote:
> http://www.phpbuilder.com/columns/smith20010821.php3?page=3
>  

bigint indexes work fine. The queries probably referenced 32-bit 
integer constants that were neither quoted nor CAST. I always start 
bigint sequences at 5 billion. This ensures that client applications 
aren't assuming 32-bit quantities that will break once ~4.2 billion 
is reached and I get index scans without quoting or casting free. 
But IIRC there's a change in the development tree to jettison the 
requirement for quoting/casting...


Mike Mascari






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

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Is indexing broken for bigint columns?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] select statement against pg_stats returns inconsistent data