Re: Dynamically loaded C function performance

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Adam Palmblad <apalmblad(at)dataunison(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Dynamically loaded C function performance
Date: 2006-05-11 22:05:23
Message-ID: 20060511220523.GT99570@pervasive.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, May 05, 2006 at 03:47:53PM -0700, 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)
>
> Besides using connection pooling, are there any options to improve
> performance?

In my experience, connection startup takes a heck of a lot longer than
50ms, so why are you worrying about 50ms for the first run of a
function?

BTW, sorry, but I don't know a way to speed this up, either.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-05-11 22:08:02 Re: Assistance with optimizing query - same SQL, different category_id = Seq Scan
Previous Message Jim C. Nasby 2006-05-11 22:04:02 Re: slow variable against int??