On Sun, Jan 30, 2011 at 05:18:15PM -0500, Tom Lane wrote:
> Andres Freund writes:
> > What happens if you change the
> > left join event.origin on event.id = origin.eventid
> > into
> > join event.origin on event.id = origin.eventid
> > ?
>
> > The EXISTS() requires that origin is not nul
On Sunday 30 January 2011 23:18:15 Tom Lane wrote:
> Andres Freund writes:
> > What happens if you change the
> >
> > left join event.origin on event.id = origin.eventid
> >
> > into
> >
> > join event.origin on event.id = origin.eventid
> >
> > ?
> >
> > The EXISTS() requires that or
Andres Freund writes:
> What happens if you change the
> left join event.origin on event.id = origin.eventid
> into
> join event.origin on event.id = origin.eventid
> ?
> The EXISTS() requires that origin is not null anyway. (Not sure why the
> planner doesn't recognize that though).
Sl
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
On Friday, January 28, 2011 06:30:19 PM yazan suleiman wrote:
> I am evaluating postgres 9 to migrate away from Oracle. The following
> query runs too slow, also please find the explain plan:
First:
explain analyze
SELECT DISTINCT
EVENT.ID
,ORIGIN.ID AS ORIGINID
,EVENT.PREFERRED_ORIGI
On Fri, Jan 28, 2011 at 09:30:19AM -0800, yazan suleiman wrote:
> I am evaluating postgres 9 to migrate away from Oracle. The following query
> runs too slow, also please find the explain plan:
>
>
> explain analyze select DISTINCT
On Fri, Jan 28, 2011 at 10:30 AM, yazan suleiman
wrote:
> I am evaluating postgres 9 to migrate away from Oracle. The following query
> runs too slow, also please find the explain plan:
>
> explain analyze select DISTINCT EVENT.ID,
I am evaluating postgres 9 to migrate away from Oracle. The following query
runs too slow, also please find the explain plan:
explain analyze select DISTINCT EVENT.ID, ORIGIN.ID AS
ORIGINID,EVENT.PREFERRED_ORIGIN_ID AS PREFERRED_ORI