Function call costs for SQL and PLPgSQL

From: Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Function call costs for SQL and PLPgSQL
Date: 2007-06-22 14:22:07
Message-ID: 200706221622.07438.vincenzo.romano@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.
I need to create a huge SQL script to load 20+ M rows in a DB.
I've been force to wrap the inserts into PG functions.
I can write them in either SQl or PLPgSQL but don't know
whether this can make a big difference as far as time of
overall execution is concerned.

Somewhere else I've been told that SQL function bodies get "inlined"
during execution. Is thus correct to consider SQL functions "faster"
that the conterpart written in PLPgSQL?

Thanks.

--
Vincenzo Romano
--
Maybe Computer will never become as intelligent as Humans.
For sure they won't ever become so stupid. [VR-1988]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2007-06-22 14:23:05 Re: How to install Postgresql on MS Vista?
Previous Message Joshua D. Drake 2007-06-22 14:19:06 Re: How to install Postgresql on MS Vista?