Re: Inconsistent use of relpages = -1

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Inconsistent use of relpages = -1
Date: 2024-10-24 15:03:15
Message-ID: 69216ef7912668c86d36f0e1db31500c48a84183.camel@j-davis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Regards,
Jeff Davis

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2024-10-24 15:11:33 Re: general purpose array_sort
Previous Message Aleksander Alekseev 2024-10-24 14:57:52 Re: general purpose array_sort