Slow C Function

From: "Adam Palmblad" <adam(at)terapeak(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Slow C Function
Date: 2006-05-09 21:57:09
Message-ID: 6B5AF6293A289F45826220B17ABE79370D5F4C@BORON.aers.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2006-05-09 23:09:19 Re: Slow C Function
Previous Message Tom Lane 2006-05-09 19:13:01 Re: [HACKERS] Big IN() clauses etc : feature proposal