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

Re: another query optimization question

From: PC Drew <drewpc(at)ibsncentral(dot)com>
To: David Teran <david(dot)teran(at)cluster9(dot)com>
Cc: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: another query optimization question
Date: 2004-01-30 18:09:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Jan 30, 2004, at 11:00 AM, David Teran wrote:
> executing a select like this:
> select
> sum(job_property_difference(t0.int_value, t1.int_value)) as rank
>   from
>   job_property t0,
>   job_property t1
>   where
>   t0.id_job_profile = 911
>   and t0.id_job_attribute = t1.id_job_attribute
>   and t1.id_job_profile in (select id_job_profile from unemployed)
>   and t1.id_job_profile <> 911;
> results in a query plan result:

What's the goal here?  Are you trying to rank by how the int_value 
relates to each other?  I'd like to know more about what kind of result 
you're trying to achieve.

PC Drew

In response to

pgsql-performance by date

Next:From: Stephan SzaboDate: 2004-01-30 18:10:16
Subject: Re: another query optimization question
Previous:From: David TeranDate: 2004-01-30 18:00:33
Subject: another query optimization question

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