Hi, On 2019-11-01 19:58:04 +1300, Thomas Munro wrote: > On Fri, Nov 1, 2019 at 7:42 PM Zhenghua Lyu <z...@pivotal.io> wrote: > > It is tricky to set disable_cost a huge number. Can we come up with > > better solution? > > What happens if you use DBL_MAX?
That seems like a bad idea - we add the cost multiple times. And we still want to compare plans that potentially involve that cost, if there's no other way to plan the query. - Andres