Re: [GENERAL] Select taking excessively long; Request help streamlining.

2007-04-11 Thread Tom Lane
Andrew Edson <[EMAIL PROTECTED]> 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.

[GENERAL] Select taking excessively long; Request help streamlining.

2007-04-11 Thread Andrew Edson
If this message has already appeared on the list, I apologize. My system tried to temporarily freeze up when I attempted to send this message a few minutes ago, and I do not know if I hit send before it halted or not. I am working with a php program that is designed to enter the database,