X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B38FBD1BB49 for ; Thu, 15 Apr 2004 11:26:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 58641-02 for ; Thu, 15 Apr 2004 11:26:41 -0300 (ADT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 94481D1B8B7 for ; Thu, 15 Apr 2004 11:26:36 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i3FETfcM030105; Thu, 15 Apr 2004 10:29:41 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i3FEQdl04160; Thu, 15 Apr 2004 10:26:39 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id FVMA9PXT; Thu, 15 Apr 2004 10:26:37 -0400 Subject: Re: Maximum Number Tables From: Robert Treat To: Ashvinder Singh Cc: pgsql-admin@postgresql.org In-Reply-To: <001d01c42046$8bed97e0$5608a8c0@ashvinder> References: <001d01c42046$8bed97e0$5608a8c0@ashvinder> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 15 Apr 2004 10:26:38 -0400 Message-Id: <1082039198.23008.816.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/229 X-Sequence-Number: 13202 On Mon, 2004-04-12 at 00:28, Ashvinder Singh wrote: > Hi All, > I have a query. > What is the maximum number of tables I can have in a PGSql Database, > without affecting performance? > Thanks in advance. > Regards, > Ashvinder The number of tables is irrelevant, it's whats stored in the tables and how you plan on using them that makes the difference. And even then it's dependent on your hardware more than PostgreSQL itself. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL