Re: Help with optimizing a sql statement - Mailing list pgsql-performance

From Vivek Khera
Subject Re: Help with optimizing a sql statement
Date
Msg-id BDD8C1A4-708A-4271-AAD4-EB6A00D0F6EE@khera.org
Whole thread Raw
In response to Re: Help with optimizing a sql statement  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
List 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


pgsql-performance by date:

Previous
From: Rafael Martinez
Date:
Subject: Re: Help with optimizing a sql statement
Next
From: Greg Stark
Date:
Subject: Re: Help with optimizing a sql statement