Postgres Pro
Downloads
Home   >   mailing lists

Re: speeding up a select with C function? - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: speeding up a select with C function?
Date
Msg-id 404BCC6F.5060903@familyhealth.com.au
Whole thread Raw
In response to speeding up a select with C function?  (David Teran <david.teran@cluster9.com>)
Responses Re: speeding up a select with C function?
List pgsql-performance
Tree view 
> explain analyze select
> ((t0.int_value-t1.int_value)*(t0.int_value-t1.int_value))
> from job_property t0, job_property t1
> where t0.id_job_profile = 5
> and t1.id_job_profile = 6
> and t1.id_job_attribute = t0.id_job_attribute
> and t1.int_value < t0.int_value;

Don't bother with C function, use SQL function instead.  You could get a
50% speedup.

Chris

pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: Using bigint needs explicit cast to use the index
Next
From: Dennis Bjorklund
Date:
Subject: Re: speeding up a select with C function?