From ashvindersingh@hfcl.com Mon Apr 12 04:28:11 2004 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 CD068D1B486 for ; Mon, 12 Apr 2004 01:28:11 -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 43559-01 for ; Mon, 12 Apr 2004 01:28:10 -0300 (ADT) Received: from support.deldsl.net (unknown [203.110.80.2]) by svr1.postgresql.org (Postfix) with ESMTP id 15430D1DB87 for ; Mon, 12 Apr 2004 01:28:08 -0300 (ADT) Received: from [203.110.91.186] by support.deldsl.net (ArGoSoft Mail Server Pro for WinNT/2000/XP, Version 1.8 (1.8.5.5)); Mon, 12 Apr 2004 09:57:20 Message-ID: <001d01c42046$8bed97e0$5608a8c0@ashvinder> From: "Ashvinder Singh" To: Subject: Maximum Number Tables Date: Mon, 12 Apr 2004 09:58:01 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001A_01C42074.A46D7AF0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=BAYES_50, HTML_50_60, HTML_MESSAGE, RCVD_IN_DSBL X-Spam-Level: X-Archive-Number: 200404/198 X-Sequence-Number: 13171 This is a multi-part message in MIME format. ------=_NextPart_000_001A_01C42074.A46D7AF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All,=20 I have a query. What is the maximum number of tables I can have in a PGSql Database, withou= t affecting performance? Thanks in advance. Regards, Ashvinder ------=_NextPart_000_001A_01C42074.A46D7AF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi All,
I have a query.
What is the maximum number of tables I can= have in=20 a PGSql Database, without affecting performance?
Thanks in advance.
Regards,
Ashvinder
------=_NextPart_000_001A_01C42074.A46D7AF0-- From xzilla@users.sourceforge.net Thu Apr 15 14:26:40 2004 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 From tgl@sss.pgh.pa.us Thu Apr 15 23:33:35 2004 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 4EF2DD1E944 for ; Thu, 15 Apr 2004 20:33:35 -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 48174-08 for ; Thu, 15 Apr 2004 20:33:40 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4EDBFD1E1F3 for ; Thu, 15 Apr 2004 20:33:33 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3FNXfXd022273; Thu, 15 Apr 2004 19:33:41 -0400 (EDT) To: Robert Treat Cc: Ashvinder Singh , pgsql-admin@postgresql.org Subject: Re: Maximum Number Tables In-reply-to: <1082039198.23008.816.camel@camel> References: <001d01c42046$8bed97e0$5608a8c0@ashvinder> <1082039198.23008.816.camel@camel> Comments: In-reply-to Robert Treat message dated "15 Apr 2004 10:26:38 -0400" Date: Thu, 15 Apr 2004 19:33:41 -0400 Message-ID: <22272.1082072021@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/233 X-Sequence-Number: 13206 Robert Treat writes: > On Mon, 2004-04-12 at 00:28, Ashvinder Singh wrote: >> What is the maximum number of tables I can have in a PGSql Database, >> without affecting performance? > The number of tables is irrelevant, Not necessarily ... if you are using a filesystem in which directory lookups in large directories are inefficient, you could have a problem, since each table will correspond to a file within the database directory. If you're planning on having more than a few thousand tables you'll want to choose a filesystem that copes well with large directories. But having said that, an application that needs several thousand distinct tables is usually an application that needs a redesign. Consider folding the data into fewer tables with more key columns. regards, tom lane