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

From Merlin Moncure
Subject Re: Speed of different procedural language
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DDBAE@Herge.rcsinc.local
Whole thread Raw
In response to Speed of different procedural language  ("Ben Trewern" <ben.trewern@_nospam_mowlem.com>)
List pgsql-performance
Tom Lane wrote:
> I'd expect plpgsql to suck at purely computational tasks, compared to
> the other PLs, but to win at tasks involving database access.  These

There you go...pl/pgsql is pretty much required learning (it's not
hard).  For classic data processing tasks, it is without peer.  I would
generalize that a large majority of tasks fall under this category.
pl/pgsql is quick, has a low memory profile, and you can cut sql
directly in code instead of through a proxy object...I could go on and
on about how useful and important that is.

merlin



pgsql-performance by date:

Previous
From: Szűcs Gábor
Date:
Subject: Re: Wrong index used when ORDER BY LIMIT 1
Next
From: Markus Schaber
Date:
Subject: Re: MySQL is faster than PgSQL but a large margin in