Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UcVZw-0000s9-KZ for pgsql-performance@arkaria.postgresql.org; Wed, 15 May 2013 06:52:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UcVZv-0003uJ-S6 for pgsql-performance@arkaria.postgresql.org; Wed, 15 May 2013 06:52:47 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UcVZv-0003uE-2x for pgsql-performance@postgresql.org; Wed, 15 May 2013 06:52:47 +0000 Received: from cl-2390.ham-01.de.sixxs.net ([2001:6f8:900:955::2] helo=feynman.df7cb.de) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UcVZk-0006Nj-SL for pgsql-performance@postgresql.org; Wed, 15 May 2013 06:52:46 +0000 Received: from msgid.df7cb.de (lehmann.df7cb.de [IPv6:2001:6f8:10ee:e:136::2]) (using TLSv1 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id D7B1A697BC for ; Wed, 15 May 2013 08:52:34 +0200 (CEST) Date: Tue, 14 May 2013 23:52:29 -0700 From: Christoph Berg To: pgsql-performance@postgresql.org Subject: Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Message-ID: <20130515065228.GE704@msgid.df7cb.de> Mail-Followup-To: Christoph Berg , pgsql-performance@postgresql.org References: <20130430112055.GA27525@msgid.df7cb.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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 -- cb@df7cb.de | http://www.df7cb.de/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance