Re: What language is faster, C or PL/PgSQL? - Mailing list pgsql-general

From Carlo Stonebanks
Subject Re: What language is faster, C or PL/PgSQL?
Date
Msg-id 033801ce016b$c6b03c10$5410b430$@sympatico.ca
Whole thread Raw
In response to What language is faster, C or PL/PgSQL?  (Karel Riverón Escobar<kescobar@estudiantes.uci.cu>)
Responses Re: What language is faster, C or PL/PgSQL?  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Here is an advantage Plpgsql has:
http://www.postgresql.org/docs/9.1/static/plpgsql-expressions.html

=20

I guess you can offset this by creating your own prepared statements in =
C.
Otherwise, I can=92t think of how C could be slower. I would choose C =
for
functions that don=92t have SQL statements in them =96 e.g. math and =
string
processing.=20

=20

From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Karel River=F3n
Escobar
Sent: February 2, 2013 10:42 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] What language is faster, C or PL/PgSQL?

=20

Hi people,

I need to write an algorithm for processing large amounts of data. I =
want to
write a function on PgAdmin 3 to solve my problem. I need to know what
language should be used, C or PL/PgSQL?=20

Needless to say, what I need is quickly. What language is faster, C or
PL/PgSQL?=20

=20

Greetings, Karel River=F3n
University of Informatics Science=20

pgsql-general by date:

Previous
From: Ovnicraft
Date:
Subject: Re: What language is faster, C or PL/PgSQL?
Next
From: Edson Richter
Date:
Subject: Diferences between IN and EXISTS?