Re: [PERFORM] Slow C Function

2006-05-09 Thread Tom Lane
"Adam Palmblad" <[EMAIL PROTECTED]> writes: > We've got a C function that we use here and we find that for every > connection, the first run of the function is much slower than any > subsequent runs. ( 50ms compared to 8ms) Perhaps that represents the time needed to load the dynamic library into t

Re: [PERFORM] Slow C Function

2006-05-09 Thread Joshua D. Drake
Adam Palmblad wrote: Hi, We've got a C function that we use here and we find that for every connection, the first run of the function is much slower than any subsequent runs. ( 50ms compared to 8ms) That is fairly standard because the data will be cached. Besides using connection pooling,

[PERFORM] Slow C Function

2006-05-09 Thread Adam Palmblad
Hi, We've got a C function that we use here and we find that for every connection, the first run of the function is much slower than any subsequent runs. ( 50ms compared to 8ms) Besides using connection pooling, are there any options to improve performance? By the way, we are using pg version