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@sra.co.jp

Fri, 24 Jul 1998 11:56:20 +0900
t-ishii@sra.co.jp
limitaion of PostgreSQL