From: ktm@rice.edu <ktm@rice.edu>
To: Christoph Berg <cb@df7cb.de>
To: pgsql-performance@postgresql.org
Subject: Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
Date: Wed, 15 May 2013 08:52:28 -0500
Message-ID: <20130515135228.GI27807@aart.rice.edu> (raw)
In-Reply-To: <20130515065228.GE704@msgid.df7cb.de>
References: <20130430112055.GA27525@msgid.df7cb.de>
<op.ww1gv9fd34t2sn@markf.office.supranet.net>
<20130515065228.GE704@msgid.df7cb.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On Tue, May 14, 2013 at 11:52:29PM -0700, Christoph Berg wrote:
> Re: Mark Felder 2013-05-13 <op.ww1gv9fd34t2sn@markf.office.supranet.net>
> > 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ktm@rice.edu, cb@df7cb.de
Subject: Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
In-Reply-To: <20130515135228.GI27807@aart.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox