Re: estimation problems for DISTINCT ON with FDW
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Etsuro Fujita <etsuro.fujita@gmail.com>
Cc: Jeff Janes <jeff.janes@gmail.com>,
pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2020-07-02T20:19:43Z
Lists: pgsql-hackers
Attachments
- clamp-foreign-table-tuples-estimate.patch (text/x-diff) patch
Concretely, I now propose the attached, which seems entirely safe to back-patch. regards, tom lane
Commits
-
Clamp total-tuples estimates for foreign tables to ensure planner sanity.
- d83d59e42d0c 9.5.23 landed
- 69a3fe6e639a 9.6.19 landed
- 5144a40f3fa7 10.14 landed
- ef799bdd04ee 11.9 landed
- ca5e93f769e1 14.0 landed
- 9233624b128b 13.0 landed
- 153c14cdd714 12.4 landed