Postgres Pro
Downloads
Home   >   mailing lists

Thread: rewrite pl/pgsql functions to c - remote job

rewrite pl/pgsql functions to c - remote job

From
Marek Lewczuk
Date:
Hello all,
I'm looking for a C developer that is able to rewrite pl/pgsql functions
to PostgreSQL c functions - because we need better performance we would
like to have all important functions rewritten to c (looking from
pl/pgsql point of view they are not complicated, so I thing that an C
export should do it in a moment). If any of you have time and want to
earn some money, please write me an email.

Best regards,
ML

Re: rewrite pl/pgsql functions to c - remote job

From
Richard Huxton
Date:
Marek Lewczuk wrote:
> Hello all,
> I'm looking for a C developer that is able to rewrite pl/pgsql functions
> to PostgreSQL c functions

You might want to post this to the -jobs mailing list instead.

--
   Richard Huxton
   Archonet Ltd

Re: rewrite pl/pgsql functions to c - remote job

From
"Merlin Moncure"
Date:
On Dec 14, 2007 7:50 AM, Marek Lewczuk <newsy@lewczuk.com> wrote:
> Hello all,
> I'm looking for a C developer that is able to rewrite pl/pgsql functions
> to PostgreSQL c functions - because we need better performance we would
> like to have all important functions rewritten to c (looking from
> pl/pgsql point of view they are not complicated, so I thing that an C
> export should do it in a moment). If any of you have time and want to
> earn some money, please write me an email.

Out of curiosity, what are you trying to speed up by moving to C?
some things _are_ faster in C procedures, but usually not in the
manner you would expect.  The big reason to write C procedures IMO is
to do things that are normally not possible in other languages.

merlin

Re: rewrite pl/pgsql functions to c - remote job

From
Stephen Frost
Date:
* Marek Lewczuk (newsy@lewczuk.com) wrote:
> I'm looking for a C developer that is able to rewrite pl/pgsql functions to
> PostgreSQL c functions - because we need better performance we would like
> to have all important functions rewritten to c (looking from pl/pgsql point
> of view they are not complicated, so I thing that an C export should do it
> in a moment). If any of you have time and want to earn some money, please
> write me an email.

As mentioned in another post- you may or may not get the performance
increase you're looking for by moving the functions to C.  Can you post
the pl/pgsql functions somewhere and/or describe what in them is being
slow?  It'd go a long way towards figuring out if C would actually help
all that much or not.

    Stephen
Attachment