pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedMinor accuracy issue
2+ messages / 2 participants
[nested] [flat]
* Minor accuracy issue
@ 2024-06-04 19:27 PG Doc comments form <noreply@postgresql.org>
2024-06-05 08:46 ` Re: Minor accuracy issue David Rowley <dgrowleyml@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2024-06-04 19:27 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: boopalan_sjb@yahoo.co.in
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 ?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Minor accuracy issue
2024-06-04 19:27 Minor accuracy issue PG Doc comments form <noreply@postgresql.org>
@ 2024-06-05 08:46 ` David Rowley <dgrowleyml@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David Rowley @ 2024-06-05 08:46 UTC (permalink / raw)
To: boopalan_sjb@yahoo.co.in; pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-06-05 08:46 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-04 19:27 Minor accuracy issue PG Doc comments form <noreply@postgresql.org>
2024-06-05 08:46 ` David Rowley <dgrowleyml@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox