Slow C Function - Mailing list pgsql-performance

From Adam Palmblad
Subject Slow C Function
Date
Msg-id 6B5AF6293A289F45826220B17ABE79370D5F4C@BORON.aers.local
Whole thread Raw
Responses Re: Slow C Function
Re: Slow C Function
List pgsql-performance
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 8.1.3.

-Adam


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Big IN() clauses etc : feature proposal
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Slow C Function