| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | boopalan_sjb(at)yahoo(dot)co(dot)in, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Minor accuracy issue |
| Date: | 2024-06-05 08:46:22 |
| Message-ID: | CAApHDvrkQ4fV7qKVXyzUtmFKKkpTNB_7V7cMm61Qcfrx0M7K2w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Wed, 5 Jun 2024 at 20:23, PG Doc comments form
<noreply(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2024-06-05 10:15:45 | Re: Need clarification on "field" |
| Previous Message | PG Doc comments form | 2024-06-04 19:54:02 | Need clarification on "field" |