Re: autoanalyze creates bad plan, manual analyze fixes it?

On Mon, Sep 14, 2020 at 7:41 PM Justin Pryzby wrote: > > On Mon, Sep 14, 2020 at 07:11:12PM -0400, Robert Treat wrote: > > Howdy folks, > > > > Recently i've run into a problem where autoanalyze is causing a query > > plan to flip over to using an index which is about 10x slower, and the > > probl

Re: autoanalyze creates bad plan, manual analyze fixes it?

út 15. 9. 2020 v 1:11 odesílatel Robert Treat napsal: > Howdy folks, > > Recently i've run into a problem where autoanalyze is causing a query > plan to flip over to using an index which is about 10x slower, and the > problem is fixed by running an alayze manually. some relevant info: > > UPDATE

Re: autoanalyze creates bad plan, manual analyze fixes it?

On Mon, Sep 14, 2020 at 07:11:12PM -0400, Robert Treat wrote: > Howdy folks, > > Recently i've run into a problem where autoanalyze is causing a query > plan to flip over to using an index which is about 10x slower, and the > problem is fixed by running an alayze manually. some relevant info: I t

autoanalyze creates bad plan, manual analyze fixes it?

Howdy folks, Recently i've run into a problem where autoanalyze is causing a query plan to flip over to using an index which is about 10x slower, and the problem is fixed by running an alayze manually. some relevant info: UPDATE sleeping_intents SET raptor_after='2020-09-14T19:21:03.581106'::time

Re: Performance Issue (Not using Index when joining two tables).

"Gopisetty, Ramesh" writes: > Thanks for looking into the problem/issue.Let me give more details about > the functions...Yes, we are using row level security. Hm. If those expensive filter functions are being injected by RLS on the target tables (rather than by something like an interm

Re: Performance Issue (Not using Index when joining two tables).

@Michael Lewis; @Tom Lane; @Tomas Vondra Hi, Thanks for looking into the problem/issue.Let me give more details about the functions...Yes, we are using row level security. Actually, we have con