(2019/02/22 17:17), Etsuro Fujita wrote:
(2019/02/21 6:19), Jeff Janes wrote:
With your tweaks, I'm still not seeing the ORDER-less LIMIT get pushed
down when using use_remote_estimate in a simple test case, either with
this set of patches, nor in the V4 set. However, without
use_remote_estimate, the LIMIT is now getting pushed with these patches
when it does not in HEAD.
Good catch! I think the root cause of that is: when using
use_remote_estimate, remote estimates obtained through remote EXPLAIN
are rounded off to two decimal places, which I completely overlooked.
Will fix. I think I can post a new version early next week.
Done. Please see [1]. Sorry for the delay.
Best regards,
Etsuro Fujita
[1] https://www.postgresql.org/message-id/5C7FC458.4020400%40lab.ntt.co.jp
