Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 02C0829B252 for ; Wed, 16 Nov 2011 02:51:42 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 34355-01 for ; Wed, 16 Nov 2011 06:51:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 074E329B251 for ; Wed, 16 Nov 2011 02:51:36 -0400 (AST) Received: from moutng.kundenserver.de ([212.227.126.171]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RQZLG-0000g4-Vu for pgsql-performance@postgresql.org; Wed, 16 Nov 2011 06:51:35 +0000 Received: from [192.168.1.3] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mrbap0) with ESMTP (Nemesis) id 0LjuXJ-1QtQNh3yNV-00cTl6; Wed, 16 Nov 2011 07:51:17 +0100 Message-ID: <4EC35D63.4000906@2ndQuadrant.com> Date: Wed, 16 Nov 2011 01:51:15 -0500 From: Greg Smith User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.16) Gecko/20111110 Icedove/3.0.11 MIME-Version: 1.0 To: Aidan Van Dyk CC: pgsql-performance@postgresql.org Subject: Re: What's the state of postgresql on ext4 now? References: <1321264847.87776.YahooMailNeo@web160808.mail.bf1.yahoo.com> <4EC33277.6000103@2ndQuadrant.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:5ImeUqEns9wLAj3RUWKUo+7/QXGiJClMK8oSja7D+DC yQv2finOYjMO2Fe0UM96CMFKXt8msrZNKW6MBro54JHxJULJox aeBgoHGj0RpE1XEf71DH8pHLYTm8kLKA72jg2tFAi8Bkp9Q8NV vTW88MJ3CnVTvc/fdfx0/dV2NsBrvdEmRl/iefnpS5Uaz4b72V KjLVxB5O+aZ8dTDEbK0wbbzMakbocm8RMvCwHJVFN/oTgZbWD/ xo4jLqEfkEzziNcWF4cFojyGJvASP2rmyMjxNxHh9dMa0wGlvu VMFWqlJp9dHN//UuI4F9bT/ZdQ6PpaINQlRz5NVq6Dv0jX2bWa /T+FFIVw4Nsj+aHvBwzg= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201111/193 X-Sequence-Number: 45704 On 11/15/2011 10:54 PM, Aidan Van Dyk wrote: > are you getting to the point of migrating large XFS filesystems to > ext4 for production databases yet? Or at least using ext4 in new > large-scale filesystems for PG? > Not really. Last time I checked (a few months ago), there were still some scary looking bugs in ext4 that concerned me, and I've seen one difficult to explain bit of corruption on it. Lots of these bugs had been fixed in the mainline Linux kernel, but I wasn't sure they'd all been backported to the sort of distributions my customers run. I expect to re-evaluate RHEL6 to see how it's doing soon, just haven't had time/requests for it. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us