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 404DD8BE.5080504@familyhealth.com.au
Whole thread Raw
In response to Re: speeding up a select with C function?  (David Teran <david.teran@cluster9.com>)
List pgsql-performance
>> Don't bother with C function, use SQL function instead.  You could get
>> a 50% speedup.
>>
> Is this always the case when using SQL instead of the C API to get
> values or only the function 'call' itself? We are thinking to use C
> functions which are optimized for the G5 altivec unit.

SQL functions are stored prepared, so there is less per-call query
planning overhead.  I'm not sure there'd be much advantage to doing them
in C...

Chris


pgsql-performance by date:

Previous
From: David Teran
Date:
Subject: Re: speeding up a select with C function?
Next
From: Tom Lane
Date:
Subject: Re: speeding up a select with C function?