Skip site navigation (1) Skip section navigation (2)

Re: hyperthreaded cpu still an issue in 8.4?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Dave Youatt <dave(at)meteorsolutions(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: hyperthreaded cpu still an issue in 8.4?
Date: 2009-07-28 23:23:29
Message-ID: dcc563d10907281623u4c04a3b2yf6699d304125f9af@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Jul 28, 2009 at 5:21 PM, Greg Smith<gsmith(at)gregsmith(dot)com> wrote:
> On Tue, 28 Jul 2009, Scott Marlowe wrote:
>
>> Just FYI, I ran the same basic test but with -c 10 since -c shouldn't
>> really be greater than -s
>
> That's only true if you're running the TPC-B-like or other write tests,
> where access to the small branches table becomes a serious hotspot for
> contention.  The select-only test has no such specific restriction as it

I thought so too, but my pgbench -S -c 16 was WAY faster on a -s 16 db
than on a -s10...

In response to

pgsql-performance by date

Next:From: Greg SmithDate: 2009-07-29 02:08:52
Subject: Re: really stupid question about checkpointing
Previous:From: Greg SmithDate: 2009-07-28 23:21:24
Subject: Re: hyperthreaded cpu still an issue in 8.4?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group