[rt-users] Performance Issues after 3.8.0 upgrade -- PostgreSQL delays

[Tom Lanyon]

For what its worth, I believe this is a big performance hit on RT  
3.6.x too, so I'd recommend fixing rather than downgrading. :)

I witnessed this query with a high execution rate on RT 3.6.1.


On 17/07/2008, at 1:28 PM, Jessie Bryan wrote:

> Update-
>
> Ok, after several hours of logging, what I see most common in the slow
> query (1s) log is:
>
> LOG:  duration: 3151.786 ms  statement: EXECUTE <unnamed>  [PREPARE:
> SELECT  * FROM Groups WHERE LOWER(Domain) = LOWER($1) AND LOWER(Type)
> = LOWER($2)]
>
> Several hundred of these queries in the slow query log data.