| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2009-07-29 02:08:52 | Re: really stupid question about checkpointing |
| Previous Message | Greg Smith | 2009-07-28 23:21:24 | Re: hyperthreaded cpu still an issue in 8.4? |