Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 29 May 2007 18:15:14 +0200
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.
- References:
- Languages and Functions
- From: Robert James
- Re: Languages and Functions
- From: Richard Huxton
- Languages and Functions
- Prev by Date: problems with SELECT query results
- Next by Date: Re: Postgres / Jaro Winkler fuzzy string matching
- Previous by thread: Re: Languages and Functions
- Next by thread: problems with SELECT query results
- Indexes: