Horton

Re: postgres_fdw: oddity in costing aggregate pushdown paths

Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>

View thread View on postgr.es
From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
To: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2019-01-23T11:35:15Z
Lists: pgsql-hackers

Attachments

(2019/01/04 20:33), Etsuro Fujita wrote:
> Here is a new version of the patch.

Attached is an updated version of the patch.

Changes:
* Fixed a stupid bug in the case when use_remote_estimate
* Fixed a typo in a comment I added
* Modified comments I added a little bit further
* Added the commit message

If there are no objections, I'll push that.

Best regards,
Etsuro Fujita

Commits

  1. postgres_fdw: Account for tlist eval costs in estimate_path_cost_size().

  2. postgres_fdw: Improve cost and size estimation for aggregate pushdown.

  3. Teach planner to account for HAVING quals in aggregation plan nodes.