Re: How many fields in a table are too many

Folling are the limitations of PostgreSQL:
Maximum size for a database    Unlimited (4 TB databases exist)
Maximum size for a table    16 TB on all operating systems
Maximum size for a row        1.6 TB
Maximum size for a field    1 GB
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

Of course, these are not actually unlimited, but limited to available disk
space and memory/swap space. Performance may suffer when these values get
unusually large.

The maximum table size of 16 TB does not require large file support from the
operating system. Large tables are stored as multiple 1 GB files so file
system size limits are not important.

The maximum table size and maximum number of columns can be increased if the
default block size is increased to 32k.

Regards,
Kallol.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of
btober@seaworthysys.com
Sent: Thursday, June 26, 2003 12:47 PM
To: m_tessier@sympatico.ca
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How many fields in a table are too many


> I have a table with 13 fields. Is that
> too many fields for one table.
> Mark
>

Thirteen? No way. I've got you beat with 21:

person_id
place_id
title_id
last_name
first_name
middle_name
gender_id
birth_year
birth_month
birth_day
deceased_year
deceased_month
deceased_day
marital_status_id
education_level
e_mail_address
social_security_no
last_update_date
updated_by
username
photograph

~B



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html