Re: [rt-users] Fw: slow query on RT 4.2.9 with postgres

2015-01-07 Thread Craig Ringer
On 01/01/2015 12:58 AM, Mark Szidik wrote: QUERY PLAN On explain.depesz.com: http://explain.depesz.com/s/Reu The great bulk of the cost is an index-only scan on acl using index acl1, as input to a nested loop. It looks like Pg might be trying to avoid using

Re: [rt-users] Fw: slow query on RT 4.2.9 with postgres

2015-01-05 Thread Alex Vandiver
On 12/31/2014 11:58 AM, Mark Szidik wrote: I just upgraded from 4.0.7 to 4.2.9 and I am running to some very slow page loads that were not an issue with the old version of RT. When simply requesting the new search page (/Search/Build.html?NewQuery=1