Postgres Pro
Downloads
Home   >   mailing lists

Re: Unexpected Performance for the Function simplify_function - Mailing list pgsql-performance

From David Rowley
Subject Re: Unexpected Performance for the Function simplify_function
Date
Msg-id CAApHDvpi1eCWyMmt-XBP16ivuQJGfVkBu6eBGEwOzk4YQAR__Q@mail.gmail.com
Whole thread Raw
In response to Re: Unexpected Performance for the Function simplify_function  (Ba Jinsheng <bajinsheng@u.nus.edu>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Andrei Lepikhov
Date:
Subject: Re: Unexpected Performance for the Function simplify_function
Next
From: SAMEER KUMAR
Date:
Subject: Re: lwlock:LockManager wait_events