X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7E564DA42A for ; Thu, 6 Oct 2005 16:27:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22187-05 for ; Thu, 6 Oct 2005 19:27:56 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 908B4DA415 for ; Thu, 6 Oct 2005 16:27:55 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 06 Oct 2005 14:27:56 -0500 Subject: Re: initlocation question From: Scott Marlowe To: Chris Hoover Cc: pgsql-admin@postgresql.org In-Reply-To: <1d219a6f0510061205q34f64ea1u3d07899e30ed8a2a@mail.gmail.com> References: <1d219a6f0510061205q34f64ea1u3d07899e30ed8a2a@mail.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1128626876.29347.237.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 06 Oct 2005 14:27:56 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200510/82 X-Sequence-Number: 19154 On Thu, 2005-10-06 at 14:05, Chris Hoover wrote: > Question, is there a limit to the number of directories you can use > with initlocation in a single PostgreSQL cluster? If so, what is the > limit (theoretical and/or practical)? > > We are in 7.3 right now, but I'm also concerned about 8.x. As of 8.x, you'd probably be better served with table spaces. locations were the old school way of working around a lack of table spaces. There's no limit I know of, certainly not one you're likely to hit for any rational installation.