Re: Performance issues in query with multiple joins

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Παρασκευη Πασσαρη <passari(dot)paraskevi(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Performance issues in query with multiple joins
Date: 2023-04-28 14:07:47
Message-ID: 1339836.1682690867@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?UTF-8?B?zqDOsc+BzrHPg866zrXPhc63IM6gzrHPg8+DzrHPgc63?= <passari(dot)paraskevi(at)gmail(dot)com> writes:
> We are facing a performance issue with the following query. Executing this
> query takes about 20 seconds.

Raising join_collapse_limit (to more than the number of joins in
the query) might help. But I think really if performance is a
problem you should think about ditching the star schema design.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2023-05-01 04:15:56 Re: Performance issues in query with multiple joins
Previous Message David G. Johnston 2023-04-28 13:03:13 Performance issues in query with multiple joins