Re: Help with optimizing a sql statement

From: Vivek Khera <vivek(at)khera(dot)org>
To: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help with optimizing a sql statement
Date: 2006-02-10 02:28:53
Message-ID: BDD8C1A4-708A-4271-AAD4-EB6A00D0F6EE@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Feb 9, 2006, at 6:36 PM, Rafael Martinez wrote:

> This is an application that we have not programmed, so I am not sure
> what they are trying to do here. I will contact the developers.
> Tomorrow
> I will try to test some of your suggestions.

well, obviously you're running RT... what you want to do is update
all your software to the latest versions. in particular update RT to
3.4.5 and all the dependent modules to their latest. We run with Pg
8.0 which is plenty fast. one of these days I'll update to 8.1 but
need to test it out first. i'm not sure how much RT has been tested
against 8.1

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2006-02-10 06:05:42 Re: Help with optimizing a sql statement
Previous Message Rafael Martinez 2006-02-09 23:36:34 Re: Help with optimizing a sql statement