Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8613C2E0032 for ; Tue, 19 Feb 2008 17:58:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 78029-01 for ; Tue, 19 Feb 2008 17:58:49 -0400 (AST) Received: from supernews.unixathome.org (supernews.unixathome.org [216.168.29.4]) by postgresql.org (Postfix) with ESMTP id 7AF0F2E002C for ; Tue, 19 Feb 2008 17:58:52 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by supernews.unixathome.org (Postfix) with ESMTP id 512C91703F; Tue, 19 Feb 2008 21:58:50 +0000 (GMT) X-Virus-Scanned: amavisd-new at unixathome.org Received: from supernews.unixathome.org ([127.0.0.1]) by localhost (supernews.unixathome.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id u1G+a8OKEjcA; Tue, 19 Feb 2008 21:58:47 +0000 (GMT) Received: from afiliascx2.afilias.com (ismtp.afilias.com [216.217.55.254]) by supernews.unixathome.org (Postfix) with ESMTP id 636AF17038; Tue, 19 Feb 2008 21:58:47 +0000 (GMT) Message-ID: <47BB50FB.4060608@langille.org> Date: Tue, 19 Feb 2008 16:58:19 -0500 From: Dan Langille Organization: The FreeBSD Diary User-Agent: Thunderbird 2.0.0.9 (X11/20071207) MIME-Version: 1.0 To: Erik Jones CC: pgsql-performance@postgresql.org Subject: Re: wal_sync_methods for AIX References: <1959485A-0DC4-4EA3-864A-D40A7F8AA094@langille.org> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/232 X-Sequence-Number: 28774 Erik Jones wrote: > > On Feb 15, 2008, at 3:55 PM, Dan Langille wrote: > >> We're using PostgreSQL 8.1.11 on AIX 5.3 and we've been doing some >> playing around >> with various settings. So far, we've (I say we, but it's another guy >> doing the work) found >> that open_datasync seems better than fsync. By how much, we have not >> yet determined, >> but initial observations are promising. > > Here's a good explanation (by the Greg Smith) on the different sync > methods. It basically says that if you have open_datasync available, > it'll probably beat everything else. Where is that explanation? -- Dan Langille BSDCan - The Technical BSD Conference : http://www.bsdcan.org/ PGCon - The PostgreSQL Conference: http://www.pgcon.org/