David Rowley <dgrowle...@gmail.com> writes:
> On Thu, 7 Mar 2024 at 23:40, Andy Fan <zhihuifan1...@163.com> wrote: >> >> David Rowley <dgrowle...@gmail.com> writes: >> > If you don't want the planner to use the statistics for the column why >> > not just do the following? >> >> Acutally I didn't want the planner to ignore the statistics totally, I >> want the planner to treat the "Const" which probably miss optimizer part >> average, which is just like what we did for generic plan for the blow >> query. > > I'm with Andrei on this one and agree with his "And it is just luck > that you've got the right answer". Any example to support this conclusion? and what's the new problem after this? -- Best Regards Andy Fan