Csaba Nagy wrote: > [snip] > > We hope to have shared row locks in 8.1 for this usage. > > This feature is one I'm really waiting for ! Is there any estimate when > 8.1 comes out ? > I know, I know, the preferred answer is "whenever it's ready", but if > 8.1 is not that far away, and shared row locking will be in it, I won't > bother patching 8.0 to skip FK parent row locking altogether (which is > not the most orthodox way to avoid the FK related deadlocks)... I would guess 8.1 is perhaps a year away. -- Bruce Momjian | http://candle.pha.pa.us pgman@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
