Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wd1ux-0007kS-0z for pgsql-performance@arkaria.postgresql.org; Wed, 23 Apr 2014 18:29:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Wd1uw-0000is-Eo for pgsql-performance@arkaria.postgresql.org; Wed, 23 Apr 2014 18:29:10 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wd1uu-0000gk-I3 for pgsql-performance@postgresql.org; Wed, 23 Apr 2014 18:29:08 +0000 Received: from smtp.01.com ([199.36.142.181]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wd1ur-0000JT-UR for pgsql-performance@postgresql.org; Wed, 23 Apr 2014 18:29:07 +0000 Received: from localhost (localhost [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id 7CF8929C93E; Wed, 23 Apr 2014 13:29:05 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-1.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id P4dOtu6y80CQ; Wed, 23 Apr 2014 13:29:05 -0500 (CDT) Received: from smtp.01.com (localhost [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id 5EFA529C93C; Wed, 23 Apr 2014 13:29:05 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id 5142D29C93E; Wed, 23 Apr 2014 13:29:05 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-1.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id 4-2Agpea3uUZ; Wed, 23 Apr 2014 13:29:05 -0500 (CDT) Received: from [172.47.23.102] (50-0-190-100.dsl.dynamic.sonic.net [50.0.190.100]) by smtp-out-1.01.com (Postfix) with ESMTPSA id AA68C29C93C; Wed, 23 Apr 2014 13:29:03 -0500 (CDT) Message-ID: <5358066C.3000407@agliodbs.com> Date: Wed, 23 Apr 2014 11:29:00 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.4.0 MIME-Version: 1.0 To: Mel Llaguno , "pgsql-performance@postgresql.org" Subject: Re: HFS+ pg_test_fsync performance References: <535800CB.7060609@agliodbs.com> In-Reply-To: X-Enigmail-Version: 1.6 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 04/23/2014 11:19 AM, Mel Llaguno wrote: > Josh, >=20 > Thanks for the feedback. Given the prevalence of SSDs/VMs, it would be > useful to start collecting stats/tuning for different operating systems > for things like fsync (and possibly bonnie++/dd). If the community is > interested, I=C2=B9ve got a performance lab that I=C2=B9d be willing to h= elp run > tests on. Having this information would only improve our ability to > support our customers. That would be terrific. I'd also suggest running the performance test you have for your production workload, and we could run some different sizes of pgbench. I'd be particularly interested in the performance of ZFS tuning options on Linux ... --=20 Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance