Re: Speed of different procedural language - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Speed of different procedural language
Date
Msg-id 20051221110647.GA17360@uio.no
Whole thread Raw
In response to Speed of different procedural language  ("Ben Trewern" <ben.trewern@_nospam_mowlem.com>)
Responses Re: Speed of different procedural language  (Michael Fuhr <mike@fuhr.org>)
List pgsql-performance
On Sun, Dec 18, 2005 at 01:10:21AM -0000, Ben Trewern wrote:
> I know I should be writing these in C but that's a bit beyond me.  I was
> going to try PL/Python or PL/Perl or even PL/Ruby.  Has anyone any idea
> which language is fastest, or is the data access going to swamp the overhead
> of small functions?

I'm not sure if it's what you ask for, but there _is_ a clear difference
between the procedural languages -- I've had a 10x speed increase from
rewriting PL/PgSQL stuff into PL/Perl, for instance. I'm not sure which ones
would be faster, though -- I believe Ruby is slower than Perl or Python
generally, but I don't know how it all works out in a PL/* setting.

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: SAN/NAS options
Next
From: "Alban Medici \(NetCentrex\)"
Date:
Subject: Re: [GENERAL] need help