[rt-users] Extremely slow response when adding comment or change people

[Vajkó Péter]

Jamie Wilkinson wrote:
>>RT 3.0.2pre3 with postgresql 7.3 is extremely slow at these actions. It 
>>starts a select like this:
> 
> 
>>about 150 tickets. I suspect the WhoHaveRigths sub in Users_Overlay.pm.
>>
>>Any ideas why this is happening?
> 
> 
> Not sure, but I found a speed problem with the Instance field of the Group
> table, it was a varchar(64) but it was storing integers (or null entries)
> only.
> 
> I've modified the table, converting instance to integer like so:

It did not help very much. What really helped was the upgrade to the 
latest SearchBuilder (0.81_04). 0.80 which is required by RT is not able 
to cope with Postgres.