Re: basic pgbench runs with various performance-related patches - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: basic pgbench runs with various performance-related patches
Date
Msg-id 20120125.092450.128144703244102426.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: basic pgbench runs with various performance-related patches  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
> My test was run with synchronous_commit=off, so I didn't expect the
> group commit patch to have much of an impact.  I included it mostly to
> see whether by chance it helped anyway (since it also helps other WAL
> flushes, not just commits) or whether it caused any regression.

Oh, I see.

> One somewhat odd thing about these numbers is that, on permanent
> tables, all of the patches seemed to show regressions vs. master in
> single-client throughput.  That's a slightly difficult result to
> believe, though, so it's probably a testing artifact of some kind.

Maybe kernel cache effect?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


pgsql-hackers by date:

Previous
From: Vik Reykja
Date:
Subject: Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"
Next
From: Tom Lane
Date:
Subject: Re: GUC_REPORT for protocol tunables was: Re: Optimize binary serialization format of arrays with fixed size elements