Postgres Pro
Downloads
Home   >   mailing lists

Re: LWLock contention: I think I understand the problem - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: LWLock contention: I think I understand the problem
Date
Msg-id 20020105102532G.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: LWLock contention: I think I understand the problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: LWLock contention: I think I understand the problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
> The results are shown in the attached plot.  Interesting, hmm?
> The "sweet spot" at 3 processes might be explained by assuming that
> pgbench itself chews up the fourth CPU.

To probe the theory, you could run pgbench on a different machine.

BTW, could you run the test with changing the number of CPUs? I'm
interested in how 7.2 is scale with # of processors.
--
Tatsuo Ishii

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: LWLock contention: I think I understand the problem
Next
From: Tom Lane
Date:
Subject: Re: LWLock contention: I think I understand the problem