Re: Preliminary notes about hash index concurrency (long)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Preliminary notes about hash index concurrency (long)
Date: 2003-09-01 17:17:00
Message-ID: 21038.1062436620@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> If all the code changes are only in the
> hash indexes, and they are known to be buggy, maybe we should just give
> it a shot for 7.4 knowing it probably can't get worse than it already
> is (but it could).

That's basically my opinion. It's unlikely to get more broken than it
already is. I've already found several unrelated bugs while studying
the code :-(. For starters, it doesn't come close to working correctly
when there's more than one overflow-page-bitmap page. Since we've not
heard reports of problems, I doubt anyone's exercised it with large
numbers of overflow pages.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2003-09-01 17:24:14 Re: Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...)
Previous Message Lee Kindness 2003-09-01 17:16:25 thread safety