OK, that did it. Time is now 315 ms. I am so exited working with
postgres. I really apologize for the format, my first time posting on the
list. That does not justify it though. Really thanks.
On Fri, Jan 28, 2011 at 1:19 PM, Andres Freund wrote:
> On Friday, January 28, 2011 06:30:19 PM ya
They have the same indexes, foreign keys are indexed in addition to the
search values like magnitude. Distinct does nothing to speed up the query.
If I remove the select in the where clause the time goes down to 98 ms:
select DISTINCT EVENT.ID, ORIGIN.ID AS ORIGINID,EVENT.PREFERRED_ORIGIN_ID AS
P
