Row estimate on empty tables
ref:
/messages/by-id/9772.1510348781@sss.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.
*Michael Lewis | Database Engineer*
*Entrata*
Michael Lewis <mlewis@entrata.com> writes:
ref:
/messages/by-id/9772.1510348781@sss.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