X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 084E29FB0D1 for ; Tue, 1 Aug 2006 23:44:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 73308-10 for ; Tue, 1 Aug 2006 23:44:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by postgresql.org (Postfix) with ESMTP id DB42C9FA508 for ; Tue, 1 Aug 2006 23:44:33 -0300 (ADT) Received: from 172.16.1.110 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Tue, 01 Aug 2006 22:44:24 -0400 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP01.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 1 Aug 2006 22:44:24 -0400 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Wed, 2 Aug 2006 02:44:23 +0000 User-Agent: Microsoft-Entourage/11.2.5.060620 Date: Tue, 01 Aug 2006 19:44:20 -0700 Subject: Re: XFS filessystem for Datawarehousing -2 From: "Luke Lonergan" To: "Milen Kulev" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] XFS filessystem for Datawarehousing -2 Thread-Index: Aca13Y3qzK5QDyHQEduMOAAWy4o9DA== In-Reply-To: <014401c6b5b8$98926a20$0a00a8c0@trivadis.com> MIME-Version: 1.0 X-OriginalArrivalTime: 02 Aug 2006 02:44:24.0346 (UTC) FILETIME=[9081BFA0:01C6B5DD] X-WSS-ID: 68CECE0211K1031731-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.662 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_NUMERIC_HELO X-Spam-Level: * X-Archive-Number: 200608/22 X-Sequence-Number: 20207 Milen, On 8/1/06 3:19 PM, "Milen Kulev" wrote: > Sorry, forgot to ask: > What is the recommended/best PG block size for DWH database? 16k, 32k, 64k > ? > What hsould be the relation between XFS/RAID stripe size and PG block size ? We have found that the page size in PG starts to matter only at very high disk performance levels around 1000MB/s. Other posters have talked about maintenance tasks improving in performance, but I haven't seen it. - Luke