Postgres Pro
Downloads
Home   >   mailing lists

Re: Select taking excessively long; Request help streamlining. - Mailing list pgsql-general

From Tom Lane
Subject Re: Select taking excessively long; Request help streamlining.
Date
Msg-id 5164.1176325268@sss.pgh.pa.us
Whole thread Raw
In response to Select taking excessively long; Request help streamlining.  (Andrew Edson <cheighlund@yahoo.com>)
List pgsql-general
Tree view 
Andrew Edson <cheighlund@yahoo.com> writes:
>   A copy of the statement and explain results on it appear below.  Would someone please assist me in figuring out how
tomore appropriately streamline this statement? 

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

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dumping part (not all) of the data in a database...methods?
Next
From: "Dhaval Shah"
Date:
Subject: Re: Tomcat question/problem