Postgres Pro
Downloads
Home   >   mailing lists

Performance issues in query with multiple joins - Mailing list pgsql-performance

From David G. Johnston
Subject Performance issues in query with multiple joins
Date
Msg-id CAKFQuwYbUgHKMfAWSVX32+g2=rMsJ2=mV6D6eUj9QqCCpMO-kA@mail.gmail.com
Whole thread Raw
In response to Performance issues in query with multiple joins  (Παρασκευη Πασσαρη <passari.paraskevi@gmail.com>)
List pgsql-performance
Tree view
On Friday, April 28, 2023, Παρασκευη Πασσαρη <passari.paraskevi@gmail.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.

pgsql-performance by date:

Previous
From: Παρασκευη Πασσαρη
Date:
Subject: Performance issues in query with multiple joins
Next
From: Tom Lane
Date:
Subject: Re: Performance issues in query with multiple joins