Thread: Row estimate on empty tables

Row estimate on empty tables

From
Michael Lewis
Date:
ref:

This functionality hasn't changed in the years since this post, right? I'm dealing with temp tables specifically, but seem to be getting bit by this behavior occasionally so I would like to confirm.


Michael Lewis  |  Database Engineer
Entrata

Re: Row estimate on empty tables

From
Tom Lane
Date:
Michael Lewis <mlewis@entrata.com> writes:
> ref:
> https://www.postgresql.org/message-id/9772.1510348781%40sss.pgh.pa.us
> This functionality hasn't changed in the years since this post, right? I'm
> dealing with temp tables specifically, but seem to be getting bit by this
> behavior occasionally so I would like to confirm.

We did improve matters in v14, see

https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=3d351d916

(It looks like the v14 release notes say nothing about this, which perhaps
was a bad idea.)

            regards, tom lane