Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 106959FB4E8 for ; Tue, 3 Jul 2007 11:54:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 69321-03 for ; Tue, 3 Jul 2007 11:54:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.233]) by postgresql.org (Postfix) with ESMTP id ECB079FB3B7 for ; Tue, 3 Jul 2007 11:54:39 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id h29so1376382wxd for ; Tue, 03 Jul 2007 07:54:38 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=fibUQbuLsb/ErGeWx1GL8k7nhXhX9fdcuCXUf0z99uHfSvxV9CshTg5lZwubw2t2MUKnV7OJMSz0m7+DCdOLuemwQCI299G0/9RD4LXzQO2pGUfIXQy6FxtnJ2TLq0LehbJBuql0eLM9iu37rr/OYwEjfm5brFRRIFKkHXkHh8A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Af2ZQTo5JfUEWEv0f3ofwJ1bTjpKjnsSyei6gZyDcFTssiA1zFHwbUnv47a9cI95PkMwNHnKlLRM5b0VJBokqvowr/q9xuOq4In4Vo5e/80NfVIoF2UVIWXSKwZalFhci93aR/TVpGIHPUK6lFVQv6edAAKNtN8S2sOabVFybh8= Received: by 10.70.18.11 with SMTP id 11mr7053194wxr.1183474478256; Tue, 03 Jul 2007 07:54:38 -0700 (PDT) Received: by 10.70.90.7 with HTTP; Tue, 3 Jul 2007 07:54:38 -0700 (PDT) Message-ID: <5482c80a0707030754o740c82b6s4598dc668720d014@mail.gmail.com> Date: Tue, 3 Jul 2007 16:54:38 +0200 From: Dimitri To: "PostgreSQL Performance" Subject: Filesystem Direct I/O and WAL sync option MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/9 X-Sequence-Number: 25693 All, I'm very curious to know if we may expect or guarantee any data consistency with WAL sync=OFF but using file system mounted in Direct I/O mode (means every write() system call called by PG really writes to disk before return)... So may we expect data consistency: - none? - per checkpoint basis? - full?... Thanks a lot for any info! Rgds, -Dimitri