X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 047919DCBAE for ; Mon, 5 Dec 2005 09:56:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57059-01 for ; Mon, 5 Dec 2005 09:57:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id AE4729DCAAC for ; Mon, 5 Dec 2005 09:56:54 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id B1D3A321BE; Mon, 5 Dec 2005 14:56:58 +0100 (MET) From: Olleg Samoylov X-Newsgroups: pgsql.performance Subject: Re: two disks - best way to use them? Date: Mon, 05 Dec 2005 16:56:55 +0300 Organization: Moscow Institute of Physics and Technology Lines: 13 Message-ID: References: <00fb01c5f772$59471410$0200a8c0@dell8200> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Debian Thunderbird 1.0.7 (X11/20051019) X-Accept-Language: en-us, en In-Reply-To: <00fb01c5f772$59471410$0200a8c0@dell8200> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.291 required=5 tests=[AWL=0.291] X-Spam-Score: 0.291 X-Spam-Level: X-Archive-Number: 200512/121 X-Sequence-Number: 15942 Rick Schumeyer wrote: > 1) the input data file > 2) the pg table > 3) the WAL And journal of file system, especially if you not set "noatime" mount option. WAL and file system journal like to make sync. IMHO: on first disk (raid mirror:)) I place /, pg_table and file system journal from second disk. On second /var and pg tables. Thus first disc is synced time to time, second not. -- Olleg Samoylov