Re: performance of analytical query

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Jiří Fejfar <jurafejfar(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: performance of analytical query
Date: 2021-11-12 17:55:53
Message-ID: CAHOFxGoe_PAYV3BmKBTZXqQTHuoMT1fM0+25Mr0Gcy8FDDsofw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Nov 11, 2021 at 7:42 PM Justin Pryzby <pryzby(at)telsasoft(dot)com> 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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2021-11-12 18:33:50 Re: performance of analytical query
Previous Message Ashkil Dighin 2021-11-12 14:12:30 Re: Lock contention high