Re: Languages and Functions

From: PFC <lists(at)peufeu(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>, "Robert James" <srobertjames(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Languages and Functions
Date: 2007-05-29 16:15:14
Message-ID: op.ts3jfoe5cigqcu@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>> 2. Is there any performance or other advantage to using PL/pgsql over
>> Pl/Perl or Python?

Yes, if you want to loop over large amounts of data (FOR row IN SELECT)
plpgsql will be faster since it does not have to convert the data from
postgres to python/perl format.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2007-05-29 16:15:42 Re: Postgres / Jaro Winkler fuzzy string matching
Previous Message Greg Sabino Mullane 2007-05-29 16:09:50 Re: feature suggestions