Minor accuracy issue

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: boopalan_sjb(at)yahoo(dot)co(dot)in
Subject: Minor accuracy issue
Date: 2024-06-04 19:27:56
Message-ID: 171752927650.2021730.2644698932192475349@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/limits.html
Description:

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 ?

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2024-06-04 19:50:15 I get ERROR: column "table_name" does not exist
Previous Message Amit Kapila 2024-06-04 05:56:53 Re: Ambiguous description on new columns