Postgres Pro
Downloads
Home   >   mailing lists

Re: Sun Donated a Sun Fire T2000 to the PostgreSQL - Mailing list pgsql-performance

From Tom Lane
Subject Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
Date
Msg-id 3706.1153678226@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sun Donated a Sun Fire T2000 to the PostgreSQL  (Robert Lor <Robert.Lor@Sun.COM>)
Responses Re: Sun Donated a Sun Fire T2000 to the PostgreSQL  (Robert Lor <Robert.Lor@Sun.COM>)
List pgsql-performance
Tree view 
Robert Lor <Robert.Lor@Sun.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

pgsql-performance by date:

Previous
From: "Craig A. James"
Date:
Subject: Re: Forcing using index instead of sequential scan?
Next
From: "Denis Lussier"
Date:
Subject: Re: postgres benchmarks