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

limitaion of PostgreSQL

From: t-ishii(at)sra(dot)co(dot)jp
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: limitaion of PostgreSQL
Date: 1998-07-24 02:56:20
Message-ID: 199807240256.LAA27913@srapc451.sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
Could anybody tell me how many tables/colums are allowed?

1. maximum number of tables in a database

I guess only the limitiation is OID for each table. So it's up to 2^31 
in theory?

2. maximum number of indexes in a database

ditto.

3. maximum number of tuples in a table

ditto.

4. maximum number of columns in a table

since max tuple size is ~8K, max number of columns would be:

8K/(least size data type (int2?)) = 4000

or any other limitaion?

5. maximum number of indexes in a table

at most 4 above. or any other limitation?
--
Tatsuo Ishii
t-ishii(at)sra(dot)co(dot)jp

pgsql-hackers by date

Next:From: D'Arcy J.M. CainDate: 1998-07-24 03:36:59
Subject: Re: [HACKERS] cidr
Previous:From: Richard LynchDate: 1998-07-24 02:29:23
Subject: Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

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