| From: | "Lai, Eric" <Eric(dot)Lai3(at)boeing(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Question about maximum sizes |
| Date: | 2005-03-03 23:51:20 |
| Message-ID: | 8958FAE80D5D7445A4E0293C4C01FCE41E771A@XCH-SW-1V2.sw.nos.boeing.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I was wondering if you know where I could find specifications on the
PostGresSQL 7.4.3 (the one build one used). I have information such as:
Maximum size for a database? unlimited (60GB databases
exist)
Maximum size for a table? 16 TB
Maximum size for a row? unlimited in 7.1 and later
Maximum size for a field? 1GB in 7.1 and later
Maximum number of rows in a table? unlimited
Maximum number of columns in a table? 250-1600 depending on column
types
Maximum number of indexes on a table? Unlimited
But I need additional information such as what the maximum size of an
actual index name is and stuff like that. Do you know where they might
have a more comprehensive guide or documentation that might have this
information?
__________________________
Eric Lai
Software Engineer
FCS - SOSCOE Data Modeling
Huntington Beach, CA
Cell: 213-453-6878
Desk: 714-896-5687
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wagoner | 2005-03-04 14:45:20 | User Login Authentication from Multiple IP Addresses (DHCP)? pg_ hba.conf |
| Previous Message | Ken Reid | 2005-03-03 21:56:44 | Table Partitioning |