Re: [GENERAL] Function call costs for SQL and PLPgSQL

2007-06-22 Thread Tom Lane
Vincenzo Romano <[EMAIL PROTECTED]> writes: > 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 execu

[GENERAL] Function call costs for SQL and PLPgSQL

2007-06-22 Thread Vincenzo Romano
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 t