X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9F844D1C4B8 for ; Wed, 13 Aug 2003 01:40:44 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 40253-05 for ; Tue, 12 Aug 2003 22:39:14 -0300 (ADT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by svr1.postgresql.org (Postfix) with ESMTP id CB080D1B53A for ; Tue, 12 Aug 2003 22:40:32 -0300 (ADT) Received: from mars (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9/8.12.9) with SMTP id h7D1eNLt021506; Wed, 13 Aug 2003 09:40:24 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <1da301c3613c$f8716960$2800a8c0@mars> From: "Christopher Kings-Lynne" To: "Richard Welty" , "PgSQL Performance ML" References: <71E37EF6B7DCC1499CEA0316A25683280105705B@loki.globexplorer.com> <200308121309.42169.josh@agliodbs.com> Subject: Re: Filesystems WAS: Perfomance Tuning Date: Wed, 13 Aug 2003 09:48:18 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/223 X-Sequence-Number: 3040 > there are advantages to being able to split the database across a slew of > disk drives. if we accept the notion of using the native OS filesystem on > each, it would seem that being able to direct various tables and indices to > specific drives might be a valuble capability. i know that i could go into > /var/lib/pgsql/data/base and fan the contents out, but this is unweildy and > impractical. has any consideration been given to providing a way to manage > such a deployment? We've got a little bunch of us tinkering with a tablespace implementation. However, it's been staller for a while now. Chris