X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 31F91D1C4CC for ; Mon, 21 Jul 2003 11:37:48 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 94600-10 for ; Mon, 21 Jul 2003 11:37:46 +0000 (GMT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 0E08AD1C4CB for ; Mon, 21 Jul 2003 08:37:45 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h6LBgtL2018047 for ; Mon, 21 Jul 2003 17:12:55 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by smtp.pspl.co.in (8.12.9/8.12.9) with ESMTP id h6LBgsEN018034 for ; Mon, 21 Jul 2003 17:12:54 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Mon, 21 Jul 2003 17:09:30 +0530 MIME-Version: 1.0 Subject: Re: Tuning PostgreSQL Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F1C1E4A.31965.14E5CFC2@localhost> In-reply-to: <3F1BCE3A.5080402@bytecraft.com.my> References: <3F1C0E65.27609.14A7BA43@localhost> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/328 X-Sequence-Number: 2621 On 21 Jul 2003 at 19:27, Ang Chin Han wrote: > [1] That is, AFAIK, from our testing. Please, please correct me if I'm > wrong: has anyone found that different filesystems produces wildly > different performance for postgresql, FreeBSD's filesystems not included? well, when postgresql starts splitting table files after a gig, filesystem sure makes difference. IIRC, frommy last test XFS was at least 10-15% faster than reiserfs for such databases. That was around an year back, with mandrake 8.0. Bye Shridhar -- modesty, n.: Being comfortable that others will discover your greatness.