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