Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 02D142E01ED for ; Wed, 9 Jan 2008 13:00:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 78148-07-2 for ; Wed, 9 Jan 2008 12:59:59 -0400 (AST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.229]) by postgresql.org (Postfix) with ESMTP id 6B36E2E2D4E for ; Wed, 9 Jan 2008 12:59:59 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id l8so135587nzf.28 for ; Wed, 09 Jan 2008 08:59:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=5KktCzbYD1S35S1va12CTGJlsr9b5RatTNHsigT8pn8=; b=CgouPiIJH7LrRPtqYQARzSahumHUdOGqCNe4tYvfmb5F1o9bjaNWWaEpfMrKENcTuJoZvgsDFpBgDvzApQau75xXO1WEVXdrnKjsISpAyufLIyoKvtAiU4o5EI12o9pUcfr/+SmSTpROO1USNnK3sFC6e7Y5RL+MPNRiv2CTjLs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Ee6TlsuZstMEzVZwbP7k+buU/y8lTWuhL3nA/jc+amCNNwGMYGt2/Q3SPEjaO2sJJdzQ7e0tzykB6osV1sKC8AedjlDLyh1AvNIdUV7+oAaJ9/iJWtdPZxLudlR++8Jjtqu6T5C7jDXk+gkDrJbUTpblmpT9vAbdLf+kDDod650= Received: by 10.114.77.1 with SMTP id z1mr1052450waa.56.1199897998085; Wed, 09 Jan 2008 08:59:58 -0800 (PST) Received: by 10.114.103.17 with HTTP; Wed, 9 Jan 2008 08:59:58 -0800 (PST) Message-ID: <1d4e0c10801090859l55b35082r5992a1bb81f1ec32@mail.gmail.com> Date: Wed, 9 Jan 2008 17:59:58 +0100 From: "Guillaume Smet" To: "Joshua D. Drake" Subject: Re: big database performance Cc: "Adrian Moisey" , pgsql-performance@postgresql.org In-Reply-To: <47848575.8000007@commandprompt.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4784835A.8070604@careerjunction.co.za> <47848575.8000007@commandprompt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/44 X-Sequence-Number: 28283 Hi Joshua, On Jan 9, 2008 9:27 AM, Joshua D. Drake wrote: > wal_sync_method = open_sync Do you recommend it in every situation or just because data are on a SAN? Do you have any numbers/real cases explaining this choice. Thanks. -- Guillaume