Re: Choosing Between PL/PGSQL or C/C++ for Triggers/Store

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: Clay Luther <claycle(at)cisco(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Choosing Between PL/PGSQL or C/C++ for Triggers/Store
Date: 2003-06-13 15:00:30
Message-ID: 20030613150030.GA16756@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 12, 2003 at 16:49:01 -0400,
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> wrote:
>
> Generally I'd say no, *if performance is the issue*. The main case
> (imho) you'd want to use plpgsql or sql functions is becuase they are a
> lot easier to write and maintain. If you don't care about that (and your
> skill level with C might be such that you don't) then C functions are
> the way to go.

sql functions are inlined in 7.4, so they may be faster than c functions
under many circumstances.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-06-13 15:04:50 Re: RE : PostgreSQL coredump : Couldn't find any tables,
Previous Message Tom Lane 2003-06-13 14:59:46 Re: Insert NULL for ''