Re: PostgreSQL limitations question - Mailing list pgsql-general

From David Johnston
Subject Re: PostgreSQL limitations question
Date
Msg-id A15E1024-5B1F-419C-986F-FBA551FA8A6A@yahoo.com
Whole thread Raw
In response to Re: PostgreSQL limitations question  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL limitations question  (Bartosz Dmytrak <bdmytrak@gmail.com>)
List pgsql-general
On Jul 12, 2012, at 9:44, Tom Lane <tgl@sss.pgh.pa.us> wrote:

>
> We could perhaps replace "unlimited" by the result of dividing the max
> table size by the minimum row size.  I'm not sure that would be
> particularly helpful though, since most tables are probably a good deal
> wider than the minimum row size, and so the effective limit would be
> quite a bit less.
>
>          regards, tom lane
>

How about saying: "No Fixed Limit - see Table Size"

There is a semantic difference between being limited by the file-system (thus internally unlimited) or being limited by
aninternal constraint (table size).  Pointing out the implication that a maximum table size necessarily limits the
maximumnumber of rows stored benefits a very small fraction of the audience but it doesn't cause any harm to the
remainderand doesn't cost much to implement. 

You could also provide a range:

20 to millions+; based on the max row size of 1.2TB and whatever the minimum size would result in.

David J.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL limitations question
Next
From: Stefan Schwarzer
Date:
Subject: ERROR: out of shared memory - But the table is empty