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

2020-09-14 Thread Robert Treat
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

autoanalyze creates bad plan, manual analyze fixes it?

2020-09-14 Thread Robert Treat
tes of the auto-analyze, and while the data is changing, it isn't changing that rapidly that this should make a significant difference, but I don't see any other reason that autoanalyze would produce a different result than manual analyze. All that said, any insight on the above t