On Mon, Jul 29, 2013 at 11:32:09PM +0800, Richard Colley wrote: > On 29 July 2013 23:29, Kevin Falcone <[1][email protected]> 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
pgpse2lhH96Io.pgp
Description: PGP signature
