Re: Select taking excessively long; Request help streamlining.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Edson <cheighlund(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Select taking excessively long; Request help streamlining.
Date: 2007-04-11 21:01:08
Message-ID: 5164.1176325268@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew Edson <cheighlund(at)yahoo(dot)com> writes:
> A copy of the statement and explain results on it appear below. Would someone please assist me in figuring out how to more appropriately streamline this statement?

The lack of any applicable index on ttrans seems to be the biggest
problem.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dhaval Shah 2007-04-11 21:03:22 Re: Tomcat question/problem
Previous Message Chris Fischer 2007-04-11 20:52:37 Re: SQL - finding next date