| 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: | 7920BFE6-534F-11D8-9B98-000A95EA00C0@ibsncentral.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2004-01-30 18:10:16 | Re: another query optimization question |
| Previous Message | David Teran | 2004-01-30 18:00:33 | another query optimization question |