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(-)
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 < |