Thread: Row estimate on empty tables
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
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