pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedNeed info: pl/pgsql performance
2+ messages / 2 participants
[nested] [flat]
* Need info: pl/pgsql performance
@ 2000-10-23 17:25 najm Hashmi <najm@mondo-live.com>
2000-10-31 16:20 ` Re: Need info: pl/pgsql performance Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
0 siblings, 1 reply; 2+ messages in thread
From: najm Hashmi @ 2000-10-23 17:25 UTC (permalink / raw)
To: pgsql-sql
Hi, I would to know if there is any articles or books that talk about
pl/pgsql performance especially versus C. Thanking you in advance for
your help.
Regards.
Najm
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Need info: pl/pgsql performance
2000-10-23 17:25 Need info: pl/pgsql performance najm Hashmi <najm@mondo-live.com>
@ 2000-10-31 16:20 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
0 siblings, 0 replies; 2+ messages in thread
From: Kovacs Zoltan Sandor @ 2000-10-31 16:20 UTC (permalink / raw)
To: najm Hashmi <najm@mondo-live.com>; +Cc: pgsql-sql; ltibor@mail.tiszanet.hu
On Mon, 23 Oct 2000, najm Hashmi wrote:
> Hi, I would to know if there is any articles or books that talk about
> pl/pgsql performance especially versus C. Thanking you in advance for
> your help.
I can only say what the documentation says about it in the "Overview"
section (please read it if you hadn't done it yet). In practical use I
didn't feel any disadvantages in speed comparing to simple queries from
psql prompt. Recursive PLPGSQL functions may be slow but I don't think it
depends on PLPGSQL internals---IMHO the same queries would be slow from C
as well. The performance generally depends on the number of queries you
send. I don't suggest submitting a large amount of queries to the server
waiting for a few rows of results---I think it's much better submitting a
few queries and getting lots of rows.
If a query in Postgres can be solved in a fast way using SQL queries,
from PLPGSQL you can feel the same speed. I didn't experience any
differences in speed comparing SQL language functions and PLPGSQL langauge
ones, too. For me writing PLGPSQL functions are much easier because its
logic is similar to other programming languages, not like SQL's logic. But
some people are familiar with the SQL logic. For them I suggest using SQL
functions which are in general enough for everything.
Unfortunately I didn't see any benchmark about these things. I am also
interested in them. Jan, are you still using your own created language?
Zoltan
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-10-31 16:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-23 17:25 Need info: pl/pgsql performance najm Hashmi <najm@mondo-live.com>
2000-10-31 16:20 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
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