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

From Bruce Momjian
Subject Re: Planning to force reindex of hash indexes
Date
Msg-id 200309052040.h85Ke7J15810@candle.pha.pa.us
Whole thread Raw
In response to Re: Planning to force reindex of hash indexes  ("Mendola Gaetano" <mendola@bigfoot.com>)
List pgsql-hackers
Mendola Gaetano wrote:
> "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> > "Mendola Gaetano" <mendola@bigfoot.com> writes:
> > > "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.
> >
> > > How can we avoid this kind of mess for the future ?
> >
> > Build a time machine, go back fifteen years, wave a magic wand to
> > increase the IQ levels of the Berkeley grad students?
> 
> :-)
> 
> > Sometimes we just have to change bad decisions, that's all.
> 
> I don't know how much old is the code incriminated but I mean
> there is no way to improve the code approved ?

I am not sure what you are asking, but the bug existed long before we
got it from Berkeley, and even then, it might have slipped by us anyway
without our noticing anyway  --- we are never going to be perfect.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Logging improvements and rehashing
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] Warning for missing createlang