Re: Planning to force reindex of hash indexes

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Planning to force reindex of hash indexes
Date: 2003-09-05 15:20:49
Message-ID: 003e01c373c1$5400b240$be700b3e@mm.eutelsat.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-05 15:23:20 Re: Stats Collector Error 7.4beta1 and 7.4beta2
Previous Message Jeroen Ruigrok/asmodai 2003-09-05 15:18:58 Re: 64-bit pgsql