pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpl/pgSQL versus pl/Python
2+ messages / 2 participants
[nested] [flat]
* pl/pgSQL versus pl/Python
@ 2004-01-27 18:52 Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 2+ messages in thread
From: Joshua D. Drake @ 2004-01-27 18:52 UTC (permalink / raw)
To: pgsql-performance
Hello,
With the new preload option is there any benefit/drawback to using
pl/Python versus
pl/pgSQL? And no... I don't care that pl/Python is now considered untrusted.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pl/pgSQL versus pl/Python
@ 2004-01-28 00:56 Joe Conway <mail@joeconway.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 2+ messages in thread
From: Joe Conway @ 2004-01-28 00:56 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-performance
Joshua D. Drake wrote:
> With the new preload option is there any benefit/drawback to using
> pl/Python versus pl/pgSQL?
If you're asking about relative speed, I did some *very* simple tests
and posted them here:
http://archives.postgresql.org/pgsql-patches/2003-07/msg00239.php
without preload:
=====================================================================
regression=# explain analyze select echo_plperl('hello');
Total runtime: 55.29 msec
regression=# explain analyze select echo_pltcl('hello');
Total runtime: 23.34 msec
regression=# explain analyze select echo_plpythonu('hello');
Total runtime: 32.40 msec
regression=# explain analyze select echo_plpgsql('hello');
Total runtime: 3.09 msec
with preload:
=====================================================================
regression=# explain analyze select echo_plperl('hello');
Total runtime: 5.14 msec
regression=# explain analyze select echo_pltcl('hello');
Total runtime: 7.64 msec
regression=# explain analyze select echo_plpythonu('hello');
Total runtime: 1.91 msec
regression=# explain analyze select echo_plpgsql('hello');
Total runtime: 1.35 msec
This was intended to just measure the time to execute a simple "hello
world" type of function, for the first time in a given session. I did
not repeat/average the results though, so you might want to do some of
your own testing.
Joe
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-01-28 00:56 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-27 18:52 pl/pgSQL versus pl/Python Joshua D. Drake <jd@commandprompt.com>
2004-01-28 00:56 ` Joe Conway <mail@joeconway.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox