| From: | Christophe Pettus <xof(at)thebuild(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, postgre <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Row estimates for empty tables |
| Date: | 2020-07-24 21:54:21 |
| Message-ID: | E15CF3EC-2A99-43C6-9FEA-D52B58DE9B1B@thebuild.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
> On Jul 24, 2020, at 14:09, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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* hacky than the current situation.
--
-- Christophe Pettus
xof(at)thebuild(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2020-07-24 22:26:05 | Re: bad JIT decision |
| Previous Message | Adrian Klaver | 2020-07-24 21:29:51 | Re: when is RLS policy applied |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2020-07-24 22:34:45 | Re: Row estimates for empty tables |
| Previous Message | Ranier Vilela | 2020-07-24 21:15:15 | Re: Improving connection scalability: GetSnapshotData() |