> On 20 Nov 2019, at 13:15, Andy Fan <zhihui.fan1...@gmail.com> wrote:
> 2. why pg can't do it, while greenplum can? It's worth noting that Greenplum, the example you're referring to, is using a completely different query planner, and different planners have different characteristics and capabilities. cheers ./daniel