From: Mark Felder <feld@feld.me>
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: Mon, 13 May 2013 15:08:23 -0500
Message-ID: <op.ww1gv9fd34t2sn@markf.office.supranet.net> (raw)
In-Reply-To: <20130430112055.GA27525@msgid.df7cb.de>
References: <20130430112055.GA27525@msgid.df7cb.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On Tue, 30 Apr 2013 06:20:55 -0500, Christoph Berg
<christoph.berg@credativ.de> wrote:
> Hi,
> this is more of a report than a question, because we thought this
> would be interesting to share.
> We recently (finally) migrated an Request Tracker 3.4 database running
> on 8.1.19 to 9.2.4. The queries used by rt3.4 are sometimes weird, but
> 8.1 coped without too much tuning. The schema looks like this:
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.
--
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: feld@feld.me
Subject: Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
In-Reply-To: <op.ww1gv9fd34t2sn@markf.office.supranet.net>
* 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