Performance issues in query with multiple joins

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Παρασκευη Πασσαρη <passari(dot)paraskevi(at)gmail(dot)com>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Performance issues in query with multiple joins
Date: 2023-04-28 13:03:13
Message-ID: CAKFQuwYbUgHKMfAWSVX32+g2=rMsJ2=mV6D6eUj9QqCCpMO-kA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Friday, April 28, 2023, Παρασκευη Πασσαρη <passari(dot)paraskevi(at)gmail(dot)com>
wrote:

> Dear all,
>
> We are facing a performance issue with the following query. Executing this
> query takes about 20 seconds.
> (the database version is 14.1)
>

Given the possibility of this working better in the supported 14.7 I
suggest starting with a minor version update then posting again if still
having problems.

David J.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2023-04-28 14:07:47 Re: Performance issues in query with multiple joins
Previous Message Παρασκευη Πασσαρη 2023-04-28 12:19:21 Performance issues in query with multiple joins