Marcus Engene <mengpg2(at)engene(dot)se> writes:
> Lacking index hints I have a bit of a problem with a slow select.
I don't think you need index hints. What you probably do need is to
increase join_collapse_limit and/or from_collapse_limit to deal with
this complex query as a whole.
> There are several selects looking similar to this in our application
> that suddenly jumped from a handfull of ms to many seconds.
Perhaps you had those settings adjusted properly and somebody turned
them off again?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Andres Freund||Date: 2012-07-25 17:01:17|
|Subject: Re: transactions start time|
|Previous:||From: Pavel Stehule||Date: 2012-07-25 16:19:52|
|Subject: Re: odd planner again, pg 9.0.8|