Skip site navigation (1) Skip section navigation (2)

Re: Postgres query completion status?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <rn214(at)cam(dot)ac(dot)uk>,<gwilliamson39(at)yahoo(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Postgres query completion status?
Date: 2009-11-20 15:24:17
Message-ID: 4B066042020000250002CAA3@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
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


Responses

pgsql-performance by date

Next:From: Віталій ТимчишинDate: 2009-11-20 16:34:09
Subject: Re: View based upon function won't use index on joins
Previous:From: Matthew WakelingDate: 2009-11-20 15:08:00
Subject: Re: [PERFORM] Strange performance degradation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group