| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | D'Arcy J.M. Cain | 1998-07-24 03:36:59 | Re: [HACKERS] cidr |
| Previous Message | Richard Lynch | 1998-07-24 02:29:23 | Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux] |