Skip site navigation (1) Skip section navigation (2)

postgres teoretical and (best-)pratical size limits

From: Francesco Dalla Ca' <f(dot)dallaca(at)cineca(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgres teoretical and (best-)pratical size limits
Date: 2005-06-30 10:03:47
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
I have some questions about the subject.

in the postgresql F.A.Q.:

4.4) What is the maximum size for a row, a table, and a database?

These are the limits:

    Maximum size for a database?    unlimited (32 TB databases exist)
    Maximum size for a table?    32 TB
    Maximum size for a row?    1.6TB
    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

1) How are computed the maximum size of a table?

On the manual:

A table cannot have more than 1600 columns. (In practice, the effective 
limit is lower because of tuple-length constraints.)

2) What's the tuple-length constraint? (and what's the max tuple-length?)

3) These are teoretical limits, but exists some licterature (articles, 
examples, case-studies) what addresses on pratical performance 
degradation derived from use of large tables with large amount of data? 
(eg.: max tables size suggested, max rows, max tuple size...)

Thanks for the answers and best regards.

pgsql-admin by date

Next:From: Martin FandelDate: 2005-06-30 10:41:49
Subject: Re: restore database from bare files
Previous:From: Hannes DorbathDate: 2005-06-30 09:58:39
Subject: Re: unicode

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group