Performance issues in query with multiple joins

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Performance issues in query with multiple joins
Дата
Msg-id CAKFQuwYbUgHKMfAWSVX32+g2=rMsJ2=mV6D6eUj9QqCCpMO-kA@mail.gmail.com
обсуждение исходный текст
Ответ на Performance issues in query with multiple joins  (Παρασκευη Πασσαρη <passari.paraskevi@gmail.com>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Παρασκευη Πασσαρη
Дата:
Сообщение: Performance issues in query with multiple joins
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance issues in query with multiple joins