On Fri, 25 Oct 2024 at 22:26, Ba Jinsheng <bajinsheng@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