On Fri, 25 Oct 2024 at 22:26, Ba Jinsheng <bajinsh...@u.nus.edu> wrote: > I guess the better query plan is not considered when comparing the cost of > paths?
You might want to change effective_cache_size is set high enough. Something like 50-75% of RAM is likely fine. David