Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1

От: ktm@rice.edu
Тема: Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
Дата: ,
Msg-id: 20130515135228.GI27807@aart.rice.edu
(см: обсуждение, исходный текст)
Ответ на: Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1  (Christoph Berg)
Список: pgsql-performance


On Tue, May 14, 2013 at 11:52:29PM -0700, Christoph Berg wrote:
> Re: Mark Felder 2013-05-13 <>
> > What version of DBIx-SearchBuilder do you have on that server? The
> > RT guys usually recommend you have the latest possible so RT is
> > performing the most sane/optimized queries possible for your
> > database. I honestly don't know if it will make a difference for
> > you, but it's worth a shot.
>
> That's a "never touch a running system" kind of machine there, we are
> happy that they let us finally upgrade at least the PostgreSQL part of
> the setup, so changing any perl libs there is out of the question.
>
> The version is libdbix-searchbuilder-perl 1.26-1 from Debian Sarge/3.1
> *cough*.
>
> Christoph
> --

Hi Christoph,

I understand the sentiment but you really should consider upgrading. I
think the current release is 1.63 and since it is the DB interface it
could have a positive effect on your problem not to mention that they
do fix bugs. :)

Regards,
Ken



В списке pgsql-performance по дате сообщения:

От: eggyknap
Дата:
Сообщение: Re: Thinking About Correlated Columns (again)
От: Gavin Flower
Дата:
Сообщение: Re: Thinking About Correlated Columns (again)