Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group