Re: Sun Donated a Sun Fire T2000 to the PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Lor <Robert(dot)Lor(at)Sun(dot)COM>
Cc: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
Date: 2006-07-23 18:10:26
Message-ID: 3706.1153678226@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Robert Lor <Robert(dot)Lor(at)Sun(dot)COM> writes:
> Here is the break down between exclusive & shared LWLocks. Do the
> numbers look reasonable to you?

Yeah, those seem plausible, although the hold time for
CheckpointStartLock seems awfully high --- about 20 msec
per transaction. Are you using a nonzero commit_delay?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-07-23 19:50:39 Re: [PATCHES] Generic Monitoring Framework with DTrace patch
Previous Message Tom Lane 2006-07-23 17:54:32 Re: libdir for installcheck

Browse pgsql-performance by date

  From Date Subject
Next Message Denis Lussier 2006-07-23 23:47:25 Re: postgres benchmarks
Previous Message Craig A. James 2006-07-23 14:03:59 Re: Forcing using index instead of sequential scan?