pg.ddx.io pgsql-performance@postgresql.org mailing list archive help / color / mirror / Atom feed From: Robert Lor <Robert.Lor@Sun.COM>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Tatsuo Ishii <ishii@sraoss.co.jp>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
Date: Fri, 21 Jul 2006 20:05:28 -0700
Message-ID: <44C195F8.9010409@sun.com> (raw )
In-Reply-To: <21889.1153489365@sss.pgh.pa.us >
References: <20060617.101521.95879771.t-ishii@sraoss.co.jp >
<10226.1150511655@sss.pgh.pa.us >
<20060617.111838.39487910.t-ishii@sraoss.co.jp >
<20060713.180234.45872055.t-ishii@sraoss.co.jp >
<8669.1153422118@sss.pgh.pa.us >
<44C088C8.9050303@sun.com >
<21889.1153489365@sss.pgh.pa.us >
Tom Lane wrote:
>Also, it'd be interesting to count time spent holding shared lock
>separately from time spent holding exclusive.
>
>
>
Tom,
Here is the break down between exclusive & shared LWLocks. Do the
numbers look reasonable to you?
Regards,
-Robert
bash-3.00# time ./Tom_lwlock_acquire.d `pgrep -n postgres`
********** LWLock Count: Exclusive **********
Lock Id Mode Count
ControlFileLock Exclusive 1
FreeSpaceLock Exclusive 9
XidGenLock Exclusive 202
CLogControlLock Exclusive 203
WALWriteLock Exclusive 203
BgWriterCommLock Exclusive 222
BufFreelistLock Exclusive 305
BufMappingLock Exclusive 305
ProcArrayLock Exclusive 405
FirstLockMgrLock Exclusive 670
WALInsertLock Exclusive 1616
********** LWLock Count: Shared **********
Lock Id Mode Count
CheckpointStartLock Shared 202
CLogControlLock Shared 450
SubtransControlLock Shared 776
XidGenLock Shared 2020
ProcArrayLock Shared 3778
SInvalLock Shared 4040
BufMappingLock Shared 40838
********** LWLock Time: Exclusive **********
Lock Id Combined Time (ns)
ControlFileLock 8301
FreeSpaceLock 80590
CLogControlLock 1603557
BgWriterCommLock 1607122
BufFreelistLock 1997406
XidGenLock 2312442
BufMappingLock 3161683
FirstLockMgrLock 5392575
ProcArrayLock 6034396
WALInsertLock 12277693
WALWriteLock 324869744
********** LWLock Time: Shared **********
Lock Id Combined Time (ns)
CLogControlLock 3183788
SubtransControlLock 6956229
XidGenLock 12012576
SInvalLock 35567976
ProcArrayLock 45400779
BufMappingLock 300669441
CheckpointStartLock 4056134243
real 0m24.718s
user 0m0.382s
sys 0m0.181s
view thread (30+ messages) latest in thread
Message-ID: <44C195F8.9010409@sun.com>
Permalink: ../44C195F8.9010409@sun.com/
Also on: postgresql.org/message-id/44C195F8.9010409@sun.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Robert.Lor@Sun.COM, tgl@sss.pgh.pa.us, ishii@sraoss.co.jp, pgsql-hackers@postgresql.org
Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
In-Reply-To: <44C195F8.9010409@sun.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox