Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres query completion status? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Postgres query completion status?
Date
Msg-id 4B066042020000250002CAA3@gw.wicourts.gov
Whole thread Raw
In response to Postgres query completion status?  (Richard Neill <rn214@cam.ac.uk>)
Responses Re: Postgres query completion status?
List pgsql-performance
Tree view 
Richard Neill  wrote:

> SELECT ( core.demand.qty - viwcs.wave_end_demand.qty_remaining )
>   FROM
>     core.demand,
>     viwcs.previous_wave
>     LEFT OUTER JOIN viwcs.wave_end_demand USING ( wid )
>   WHERE core.demand.id = viwcs.wave_end_demand.demand_id;

For comparison, how does this do?:

SELECT (core.demand.qty - viwcs.wave_end_demand.qty_remaining)
  FROM core.demand,
  JOIN viwcs.previous_wave
    ON (core.demand.id = viwcs.wave_end_demand.demand_id)
  LEFT OUTER JOIN viwcs.wave_end_demand USING (wid);

-Kevin

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Strange performance degradation
Next
From: Віталій Тимчишин
Date:
Subject: Re: View based upon function won't use index on joins