public inbox for [email protected]
help / color / mirror / Atom feedglossary Data page
4+ messages / 3 participants
[nested] [flat]
* glossary Data page
@ 2026-06-29 05:49 PG Doc comments form <[email protected]>
2026-06-30 13:28 ` Re: glossary Data page David G. Johnston <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: PG Doc comments form @ 2026-06-29 05:49 UTC (permalink / raw)
To: [email protected]; +Cc: [email protected]
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/18/glossary.html
Description:
> The basic structure used to store relation data. All pages are of the same
size. Data pages are typically stored on disk, each in a specific file, and
can be read to shared buffers where they can be modified, becoming dirty.
They become clean when written to disk. New pages, which initially exist in
memory only, are also dirty until written.
Am I correct in understanding from this description that all files on the
disk will be the same size?
One page = one file?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: glossary Data page
2026-06-29 05:49 glossary Data page PG Doc comments form <[email protected]>
@ 2026-06-30 13:28 ` David G. Johnston <[email protected]>
2026-06-30 15:04 ` Re: glossary Data page Yaroslav Saburov <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: David G. Johnston @ 2026-06-30 13:28 UTC (permalink / raw)
To: [email protected] <[email protected]>; [email protected] <[email protected]>
On Sunday, June 28, 2026, PG Doc comments form <[email protected]>
wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/18/glossary.html
> Description:
>
> > The basic structure used to store relation data. All pages are of the
> same
> size. Data pages are typically stored on disk, each in a specific file, and
> can be read to shared buffers where they can be modified, becoming dirty.
> They become clean when written to disk. New pages, which initially exist in
> memory only, are also dirty until written.
>
> Am I correct in understanding from this description that all files on the
> disk will be the same size?
> One page = one file?
>
No. A page is an atomic unit subset of a file. Files contain many pages.
It would be crazy to limit file sizes to 8kb when we have GB available.
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: glossary Data page
2026-06-29 05:49 glossary Data page PG Doc comments form <[email protected]>
2026-06-30 13:28 ` Re: glossary Data page David G. Johnston <[email protected]>
@ 2026-06-30 15:04 ` Yaroslav Saburov <[email protected]>
2026-06-30 16:51 ` Re: glossary Data page David G. Johnston <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Yaroslav Saburov @ 2026-06-30 15:04 UTC (permalink / raw)
To: David G. Johnston <[email protected]>; +Cc: [email protected]
Maybe these are just the intricacies of translation.
This is how I interpret it:
1) All pages are the same size.
2) Data pages are usually stored on disk,
3) each in a separate file,
> 1) All pages are of the same size.
> 2) Data pages are typically stored on disk
> 3) each in a specific file,
> 30 черв. 2026 р. о 16:28 David G. Johnston <[email protected]> пише:
>
> On Sunday, June 28, 2026, PG Doc comments form <[email protected]> wrote:
>> The following documentation comment has been logged on the website:
>>
>> Page: https://www.postgresql.org/docs/18/glossary.html
>> Description:
>>
>> > The basic structure used to store relation data. All pages are of the same
>> size. Data pages are typically stored on disk, each in a specific file, and
>> can be read to shared buffers where they can be modified, becoming dirty.
>> They become clean when written to disk. New pages, which initially exist in
>> memory only, are also dirty until written.
>>
>> Am I correct in understanding from this description that all files on the
>> disk will be the same size?
>> One page = one file?
>
> No. A page is an atomic unit subset of a file. Files contain many pages. It would be crazy to limit file sizes to 8kb when we have GB available.
>
> David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: glossary Data page
2026-06-29 05:49 glossary Data page PG Doc comments form <[email protected]>
2026-06-30 13:28 ` Re: glossary Data page David G. Johnston <[email protected]>
2026-06-30 15:04 ` Re: glossary Data page Yaroslav Saburov <[email protected]>
@ 2026-06-30 16:51 ` David G. Johnston <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: David G. Johnston @ 2026-06-30 16:51 UTC (permalink / raw)
To: Yaroslav Saburov <[email protected]>; +Cc: [email protected]
On Tue, Jun 30, 2026 at 8:04 AM Yaroslav Saburov <[email protected]>
wrote:
> Maybe these are just the intricacies of translation.
>
> This is how I interpret it:
>
>
> 1) All pages are the same size.
>
> 2) Data pages are usually stored on disk,
>
> 3) each in a separate file,
>
>
> > 1) All pages are of the same size.
>
> > 2) Data pages are typically stored on disk
>
> > 3) each in a specific file,
>
More that the author is being imprecise here so as not to overwhelm
the reader with detail.
Patches are welcome, though at present I have no intent to write one.
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2026-06-30 16:51 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-06-29 05:49 glossary Data page PG Doc comments form <[email protected]>
2026-06-30 13:28 ` David G. Johnston <[email protected]>
2026-06-30 15:04 ` Yaroslav Saburov <[email protected]>
2026-06-30 16:51 ` David G. Johnston <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox