pgsql: Round rowcount estimate for a partial path to an integer.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Round rowcount estimate for a partial path to an integer.
Date: 2016-07-03 18:54:04
Message-ID: E1bJmWq-00040b-R2@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Round rowcount estimate for a partial path to an integer.

I'd been wondering why I was sometimes seeing fractional rowcount
estimates in parallel-query situations, and this seems to be the
reason. (You won't see the fractional parts in EXPLAIN, because it
prints rowcounts with %.0f, but they are apparent in the debugger.)
A fractional rowcount is not any saner for a partial path than any
other kind of path, and it's equally likely to break cost estimation
for higher paths, so apply clamp_row_est() like we do in other places.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c89d507649df9fbc21617e02ab4d5e765a28b7df

Modified Files
--------------
src/backend/optimizer/path/costsize.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2016-07-03 19:35:37 pgsql: Set correct cost data in Gather node added by force_parallel_mod
Previous Message Kevin Grittner 2016-07-03 13:32:46 Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <