Re: Row estimates for empty tables - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Row estimates for empty tables
Date
Msg-id E15CF3EC-2A99-43C6-9FEA-D52B58DE9B1B@thebuild.com
Whole thread Raw
In response to Re: Row estimates for empty tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

> On Jul 24, 2020, at 14:09, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Rather than adding another pg_class column, I'm tempted to say that
> vacuum/analyze should set relpages to a minimum of 1, even if the
> relation has zero pages.

If there's not an issue about relpages != actual pages on disk, that certain seems straight-forward, and no *more*
hackythan the current situation. 

--
-- Christophe Pettus
   xof@thebuild.com




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: when is RLS policy applied
Next
From: David Rowley
Date:
Subject: Re: bad JIT decision