Re: Inconsistent use of relpages = -1 - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Inconsistent use of relpages = -1
Date
Msg-id d429fdf5641e3bad71c0e9bcd93c814463448db0.camel@cybertec.at
Whole thread Raw
In response to Re: Inconsistent use of relpages = -1  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
On Thu, 2024-10-24 at 08:03 -0700, Jeff Davis wrote:
> On Thu, 2024-10-24 at 05:01 +0300, Laurenz Albe wrote:
> > What you write above indicates that "relpages" = 0 and "reltuples" >
> > 0
> > would also be acceptable.
>
> As Tom pointed out, that creates a risk that it's interpreted as
> infinite tuple denisity.
>
> The only functional change in my patch is to create the partitioned
> table with relpages=-1 to be more consistent with the value after it's
> analyzed.

Great, then it cannot be wrong.  Sorry for the noise!

Yours,
Laurenz Albe



pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: Pgoutput not capturing the generated columns
Next
From: Fujii Masao
Date:
Subject: Re: Refactor GetLockStatusData() by skipping unused backends and groups