Re: Planning to force reindex of hash indexes

Поиск
Список
Период
Сортировка
От Mendola Gaetano
Тема Re: Planning to force reindex of hash indexes
Дата
Msg-id 003e01c373c1$5400b240$be700b3e@mm.eutelsat.org
обсуждение исходный текст
Ответ на Planning to force reindex of hash indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Planning to force reindex of hash indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> I've found a number of infelicities in the hash index code that can't be
> fixed without an on-disk format change.  The biggest one is that the 
> hashm_ntuples field in hash meta pages is only uint32, meaning that
> hash index space management will become confused if the number of
> entries exceeds 4G.  I'd like to change it to a "double", and clean up
> a couple other uglinesses at the same time.

How can we avoid this kind of mess for the future ?

Regards
Gaetano Mendola



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Stats Collector Error 7.4beta1 and 7.4beta2
Следующее
От: Jeroen Ruigrok/asmodai
Дата:
Сообщение: Re: 64-bit pgsql