Skip site navigation (1) Skip section navigation (2)

Re: Maximum Number Tables

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Ashvinder Singh <ashvindersingh(at)hfcl(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Maximum Number Tables
Date: 2004-04-15 14:26:38
Message-ID: 1082039198.23008.816.camel@camel (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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

In response to


pgsql-admin by date

Next:From: Robert TreatDate: 2004-04-15 14:31:34
Subject: Re: Postgresql Backup & Dump
Previous:From: Paul BreenDate: 2004-04-15 12:47:38
Subject: Re: Real time replication of PG DBs accross two servers -

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group