=?UTF-8?B?zqDOsc+BzrHPg866zrXPhc63IM6gzrHPg8+DzrHPgc63?= <[email protected]> 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
