Re: relpages in pg_class

2022-08-21 Thread Shangzi Xie
Page and block can be used interchangeably, but the description of relpages in the documentation can be confusing to someone who doesn't care much about the difference between page and block. When I want to count pages from a table, maybe the keywords I should look for should be "the number of", bu

Re: relpages in pg_class

2022-08-19 Thread Bruce Momjian
On Fri, Aug 19, 2022 at 11:25:52AM -0700, Peter Geoghegan wrote: > On Fri, Aug 19, 2022 at 9:40 AM Tom Lane wrote: > > Yeah, we use "blocks" and "pages" interchangeably, which is something > > I don't feel a need to change; but evidently the OP didn't realize that. > > This is a job for the glossa

Re: relpages in pg_class

2022-08-19 Thread Peter Geoghegan
On Fri, Aug 19, 2022 at 9:40 AM Tom Lane wrote: > Yeah, we use "blocks" and "pages" interchangeably, which is something > I don't feel a need to change; but evidently the OP didn't realize that. > This is a job for the glossary, perhaps? I think that they're synonyms that can often (but not alway

Re: relpages in pg_class

2022-08-19 Thread Tom Lane
Alvaro Herrera writes: > On 2022-Aug-19, Bruce Momjian wrote: >> Well, blocks and pages are the same size, so I don't see the problem. > If you think about operating system "blocks" rather than Postgres > "blocks", I can see how this can be interpreted differently. I'm not > sure if this is a go

Re: relpages in pg_class

2022-08-19 Thread Alvaro Herrera
On 2022-Aug-19, Bruce Momjian wrote: > On Fri, Aug 19, 2022 at 04:10:30AM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/14/catalog-pg-class.html > > Description: > > > > From source code, t

Re: relpages in pg_class

2022-08-19 Thread Bruce Momjian
On Fri, Aug 19, 2022 at 04:10:30AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/catalog-pg-class.html > Description: > > From source code, the relpage is the number of blocks. But, at the docu

relpages in pg_class

2022-08-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/catalog-pg-class.html Description: From source code, the relpage is the number of blocks. But, at the document, it is written as Size of the on-disk representation of this table in pages (