Re: lazy vxid locks, v1

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <robertmhaas(at)gmail(dot)com>,<stefan(at)kaltenbrunner(dot)cc>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: lazy vxid locks, v1
Date: 2011-06-13 12:29:18
Message-ID: 4DF5BC4E020000250003E50D@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stefan Kaltenbrunner wrote:

> on that particular 40cores/80 threads box:

> unpatched:

> c40: tps = 107689.945323 (including connections establishing)
> c80: tps = 101885.549081 (including connections establishing)

> fast locks:

> c40: tps = 215807.263233 (including connections establishing)
> c80: tps = 118266.615543 (including connections establishing)

> fast locks + lazy vxid:

> c40: tps = 223308.779212 (including connections establishing)
> c80: tps = 65738.046558 (including connections establishing)

Is there any way to disable the HT (or whatever technology attempts
to make each core look like 2)? In my benchmarking that has kept
performance from tanking as badly when a large number of processes
are contending for CPU.

-Kevin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-06-13 12:30:44 Re: FOREIGN TABLE doc fix
Previous Message Robert Haas 2011-06-13 12:22:37 Re: wrong message on REASSIGN OWNED