Re: [HACKERS] locking for unique hash indexes

2003-09-19 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: - Invent a new set of lmgr locks; call them right of insertion locks, and have one for each bucket in the hash index. Only one backend will hold the ROI lock for a given bucket at any given time. Rather than trying to invent a new set of lock IDs (which

[HACKERS] locking for unique hash indexes

2003-09-16 Thread Neil Conway
I'm working on adding support for unique indexes to the hash index code. The majority of the code is finished, with the exception of the changes to locking. My proposed changes are below -- if anyone sees a better way to do things, let me know. There's lots of info on the locking scheme used by