Re: Unexpected Performance for the Function simplify_function

[Ba Jinsheng <bajinsheng@xxxxxxxxx>]

>It looks like the better plan involves a
>nestloop with inner indexscan on lineitem, which is something whose
>estimated cost depends enormously on random_page_cost.  You've given
>us exactly zero detail about your test conditions, so it's hard to say
>more than that.

I used the default configuration in the file src/backend/utils/misc/postgresql.conf.sample

So the random_page_cost = 4.0 

Best regards,

Jinsheng Ba

Notice: This email is generated from the account of an NUS alumnus. Contents, views, and opinions therein are solely those of the sender.