Re: Obscure: correctness of lock manager???

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Schoebel-Theuer <schoebel(at)informatik(dot)uni-stuttgart(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Obscure: correctness of lock manager???
Date: 2003-08-29 14:24:14
Message-ID: 18227.1062167054@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Schoebel-Theuer <schoebel(at)informatik(dot)uni-stuttgart(dot)de> writes:
> Do you have any clue whether it really could happen that really
> NEVER any blocking occurs when running the DBT3 benachmark with 8
> or 16 parallel backend processes???

I haven't looked at dbt3 at all ... what does it do?

We do make a point of trying to prevent concurrent readers and writers
from blocking each other, so depending on how the benchmark is set up,
a low probability of lock conflict is certainly possible.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2003-08-29 14:26:30 Re: Force table to be permanently in cache?
Previous Message Robert Treat 2003-08-29 14:23:36 Re: before trigger problem