Re: LWLock contention: I think I understand the problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgman(at)candle(dot)pha(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org, jwbaker(at)acm(dot)org
Subject: Re: LWLock contention: I think I understand the problem
Date: 2002-01-03 15:20:49
Message-ID: 12767.1010071249@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-odbc

Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
> Ok, here is a pgbench (-s 10) result on an AIX 5L box (4 way).
> "7.2 with patch" is for the previous patch. "7.2 with patch (revised)"
> is for the this patch. I see virtually no improvement.

If anything, the revised patch seems to make things slightly worse :-(.
That agrees with my measurement on a single CPU.

I am inclined to use the revised patch anyway, though, because I think
it will be less prone to starvation (ie, a process repeatedly being
awoken but failing to get the lock). The original form of lwlock.c
guaranteed that a writer could not be locked out by large numbers of
readers, but I had to abandon that goal in the first version of the
patch. The second version still doesn't keep the writer from being
blocked by active readers, but it does ensure that readers queued up
behind the writer won't be released. Comments?

> Please note that xy axis are now in log scale.

Seems much easier to read this way. Thanks.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2002-01-03 15:27:03 Re: [HACKERS] Updated TODO item
Previous Message Thomas Lockhart 2002-01-03 15:11:13 Re: PGSQL - FAQ 4.1

Browse pgsql-odbc by date

  From Date Subject
Next Message Bruce Momjian 2002-01-03 17:08:34 Re: LWLock contention: I think I understand the problem
Previous Message Tatsuo Ishii 2002-01-03 09:00:10 Re: LWLock contention: I think I understand the problem