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

Maximum Number of Tables in a database

From: "Brubaker, Shane" <Shane_Brubaker(at)affymetrix(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: "Cawley, Simon" <Simon_Cawley(at)affymetrix(dot)com>
Subject: Maximum Number of Tables in a database
Date: 2002-07-25 00:29:38
Message-ID: 53386E0C47E7D41194BB0002B325C997747F2B@NTEX60 (view raw or flat)
Thread:
Lists: pgsql-admin
On the limitations page it states various maximums for PostgreSQL, but I
don't see an explicit reference to the maximum number of tables, a question
that has come up before.  

I'm guessing that the maximum number of tables is related to how much can be
stored in the pg_ tables which track the names and information of the
various fields in the database.

So, based on that, the maximum number of rows is unlimited and the maximum
size for a table is 64 TB.  So realistically, you would need an enormous
number (trillions) of tables to exceed that limit, and of course the actual
storage of those tables themselves would use up your disk long before you
ran out of room in the pg_ tables.

So I'm assuming there is no practical limit on the number of tables in a
given database.

In looking through the pg_ tables though, I don't see one that specifically
lists table names.  Is there one?  Is some information perhaps stored on
disk in the base, global, or clog areas?

We currently have a system with 100 GB of data and about 1000 tables.  We
are designing it such that there will be multiple machines in parallel, and
then within each machine a given Virtual table is broken down into many
smaller tables, so we will typically have about 1000-10,000 tables per
database.  

We'd be curious to hear of anyone who has pushed these limits further.

 

Thank You,

 

Shane Brubaker & the Transcriptome group

Responses

pgsql-admin by date

Next:From: Michael G. MartinDate: 2002-07-25 03:01:35
Subject: Re: Postgres performance slowly gets worse over a month
Previous:From: Marcos GarciaDate: 2002-07-25 00:17:59
Subject: Re: Postgres performance slowly gets worse over a month

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