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 75E64D1C96A for ; Wed, 6 Aug 2003 20:51:17 +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 71474-07 for ; Wed, 6 Aug 2003 17:49:56 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 66B16D1C4BF for ; Wed, 6 Aug 2003 17:51:06 -0300 (ADT) Received: from dev6.int.libertyrms.com ([10.1.2.212] helo=libertyrms.info) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19kVFT-0000lq-00; Wed, 06 Aug 2003 16:51:07 -0400 Received: by libertyrms.info (Postfix, from userid 1079) id A9BB5BBADC; Wed, 6 Aug 2003 16:51:07 -0400 (EDT) To: "Wilson A. Galafassi Jr." Cc: pgsql-performance@postgresql.org Subject: Re: partitioning for postgresql From: Christopher Browne Date: Wed, 06 Aug 2003 16:51:07 -0400 Message-ID: <60n0em8q84.fsf@dev6.int.libertyrms.info> User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Rational FORTRAN, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/116 X-Sequence-Number: 2933 > what is suggested partitioning schema for postgresql?? > the size of my db is 5BG and i have 36GB scsi disk! The interesting forms of partitioning kind of assume that you have multiple disk drives. If you only have one drive, then there is not terribly much reason to prefer anything much over simply having one big partition, and letting the data fall where it will. If you had two drives, then it would make sense to have data on one drive and WAL on the other. With three drives, having other I/O (such as database logging) on a third drive would have merit. But none of those approaches are useful if you only have one disk drive. -- "cbbrowne","@","libertyrms.info" Christopher Browne (416) 646 3304 x124 (land)