Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Performance issues in query with multiple joins
Date
Msg-id 1339836.1682690867@sss.pgh.pa.us
Whole thread Raw
In response to Performance issues in query with multiple joins  (Παρασκευη Πασσαρη <passari.paraskevi@gmail.com>)
List pgsql-performance
Tree view 
=?UTF-8?B?zqDOsc+BzrHPg866zrXPhc63IM6gzrHPg8+DzrHPgc63?= <passari.paraskevi@gmail.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

pgsql-performance by date:

Previous
From: "David G. Johnston"
Date:
Subject: Performance issues in query with multiple joins
Next
From: Laurenz Albe
Date:
Subject: Re: Performance issues in query with multiple joins