Re: Minor accuracy issue - Mailing list pgsql-docs

From David Rowley
Subject Re: Minor accuracy issue
Date
Msg-id CAApHDvrkQ4fV7qKVXyzUtmFKKkpTNB_7V7cMm61Qcfrx0M7K2w@mail.gmail.com
Whole thread Raw
In response to Minor accuracy issue  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
On Wed, 5 Jun 2024 at 20:23, PG Doc comments form
<noreply@postgresql.org> wrote:
> Under page "https://www.postgresql.org/docs/current/limits.html", it is
> mentioned:
>
> relation size - 32TB
> rows per table - limited by the number of tuples that can fit onto
> 4,294,967,295 pages
>
>
> 32 TB is 35,184,372,088,832 bytes (32*1024*1024*1024*1024).
> When we divide this by 8192, we get 4,294,967,296.
>
> So why limit is mentioned 4,294,967,295 pages, instead of 4,294,967,296
> pages ?

Because that's the limit.

It might be more accurate to say the relation size limit is
34359738360 kB, but do you think it's going to be better to write
that?

David



pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Need clarification on "field"
Next
From: Laurenz Albe
Date:
Subject: Re: Need clarification on "field"