| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> | 
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> | 
| Cc: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, pgsql-general(at)postgresql(dot)org | 
| Subject: | Re: hexadecimal to decimal | 
| Date: | 2003-07-31 03:56:07 | 
| Message-ID: | 27450.1059623767@sss.pgh.pa.us | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general pgsql-patches | 
Joe Conway <mail(at)joeconway(dot)com> writes:
> So based on this simple test, I'd say that if you only run the function 
> once per connect, use plpgsql, but if you run the function many times 
> during one backend session, use perl.
Presumably, the 50 msec difference represents the time to load up the
perl library and initialize a perl interpreter.
It might help if libperl were to be preloaded into the postmaster in the
way you created ... 
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-07-31 03:59:25 | Re: hexadecimal to decimal | 
| Previous Message | Tom Lane | 2003-07-31 03:40:30 | Re: Don't removes/recycles WAL files at all | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-07-31 03:59:25 | Re: hexadecimal to decimal | 
| Previous Message | Bruce Momjian | 2003-07-31 01:43:22 | Re: [PATCHES] [PATCH] Re: Why READ ONLY transactions? |