Re: [GENERAL] FKs Lock Contention

2006-06-27 Thread Bruno Wolff III
On Tue, Jun 27, 2006 at 00:52:48 -0300, Bruno Almeida do Lago <[EMAIL PROTECTED]> wrote: > > Oracle 8.1.7 used to have a severe lock contention when FKs had no index > (causing an sx table lock). AFAIK this was "fixed" on 9i with the addition > of "shared row locking". In Postgres this problem

[GENERAL] FKs Lock Contention

2006-06-26 Thread Bruno Almeida do Lago
Hello, I need some help to understand better the way PostgreSQL works internally: Oracle 8.1.7 used to have a severe lock contention when FKs had no index (causing an sx table lock). AFAIK this was "fixed" on 9i with the addition of "shared row locking". Reading the docs I found that PostgreSQL