>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.
