Re: Choosing Between PL/PGSQL or C/C++ for Triggers/Store - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Choosing Between PL/PGSQL or C/C++ for Triggers/Store
Date
Msg-id 20030613150030.GA16756@wolff.to
Whole thread Raw
In response to Re: Choosing Between PL/PGSQL or C/C++ for Triggers/Store  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
On Thu, Jun 12, 2003 at 16:49:01 -0400,
  Robert Treat <xzilla@users.sourceforge.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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Next
From: Oleg Bartunov
Date:
Subject: Re: tsearch - v2 new dict