[rt-users] New installation of 4.0.13 - performance problem viewing tickets.

[Kevin Falcone]

On Mon, Jul 29, 2013 at 11:32:09PM +0800, Richard Colley wrote:
>    On 29 July 2013 23:29, Kevin Falcone <[1]falcone at bestpractical.com> wrote:
> 
>      On Mon, Jul 29, 2013 at 04:46:25PM +0800, Richard Colley wrote:
>      > I am having a strange performance problem viewing tickets in a recent
>      > installation of RT v4.0.13 on RHEL6.4. Â DB is Postgres 9.2.
> 
>      Which version of DBD::Pg are you using?
> 
>    DBD::Pg is version 2.19.3.

That's new enough to no longer generate incorrect SQL, but RT doesn't
use the DBIx::SearchBuilder functions that call column_info except
during upgrades.  As a result, I'm unsure what in RT would be
triggering the queries you're seeing.

You might turn on RT or Postgres' query logging and see if you can
figure out what happens before those queries.  Also - be suspicious of
any customizations.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130801/96ee7d50/attachment.sig>