Re: Planning to force reindex of hash indexes - Mailing list pgsql-hackers

From Mendola Gaetano
Subject Re: Planning to force reindex of hash indexes
Date
Msg-id 003e01c373c1$5400b240$be700b3e@mm.eutelsat.org
Whole thread Raw
In response to Planning to force reindex of hash indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Planning to force reindex of hash indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stats Collector Error 7.4beta1 and 7.4beta2
Next
From: Jeroen Ruigrok/asmodai
Date:
Subject: Re: 64-bit pgsql