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 6ABFB9DD767 for ; Fri, 2 Dec 2005 15:00:08 -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 78144-08 for ; Fri, 2 Dec 2005 15:00:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from rwcrmhc12.comcast.net (unknown [216.148.227.153]) by postgresql.org (Postfix) with ESMTP id 576B09DD764 for ; Fri, 2 Dec 2005 15:00:03 -0400 (AST) Received: from dell8200 (pcp09613107pcs.rte20201.de.comcast.net[68.82.197.68]) by comcast.net (rwcrmhc13) with SMTP id <2005120218581801500ih0eme>; Fri, 2 Dec 2005 18:58:18 +0000 From: "Rick Schumeyer" To: Subject: two disks - best way to use them? Date: Fri, 2 Dec 2005 13:58:13 -0500 Message-ID: <00fb01c5f772$59471410$0200a8c0@dell8200> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00FC_01C5F748.70710C10" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[AWL=-0.000, HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/71 X-Sequence-Number: 15892 This is a multi-part message in MIME format. ------=_NextPart_000_00FC_01C5F748.70710C10 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit I installed another drive in my linux pc in an attempt to improve performance on a large COPY to a table with a geometry index. Based on previous discussion, it seems there are three things competing for the hard drive: 1) the input data file 2) the pg table 3) the WAL What is the best way to distribute these among two drives? From Tom's comments I would think that the pg table and the WAL should be separate. Does it matter where the input data is? ------=_NextPart_000_00FC_01C5F748.70710C10 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

I installed another drive in my linux pc in an = attempt to improve performance

on a large COPY to a table with a geometry = index.

 

Based on previous discussion, it seems there are = three things competing for the hard

drive:

 

1)       the input data file

2)       the pg table

3)       the WAL

 

What is the best way to distribute these among two drives?  From Tom’s comments

I would think that the pg table and the WAL should be separate.  Does it matter where

the input data is?

------=_NextPart_000_00FC_01C5F748.70710C10--