Re: performance of analytical query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Nov 11, 2021 at 7:42 PM Justin Pryzby <pryzby@xxxxxxxxxxxxx> wrote:
BTW, we disable nested loops for the our analytic report queries.  I have never
been able to avoid pathological plans any other way.

Curious, do you see any problems from that? Are there certain nodes that really are best suited to a nested loop like a lateral subquery?

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux