Postgres Pro
Downloads
Home   >   mailing lists

Performance: Perl-DBI vs. PG Stored Procedures - Mailing list pgsql-general

From David Link
Subject Performance: Perl-DBI vs. PG Stored Procedures
Date
Msg-id 3BFA8059.95E29280@soundscan.com
Whole thread Raw
List pgsql-general
Tree view 
Hi,

Could there be performance gains by using PG stored procedures rather
than using generic Perl DBI programs?

Namely for a task that loops thru a cursor of several 50,000 rows and
does UPDATES or INSERTS back into that same table.  It is takes hours.

Thanks, David

pgsql-general by date:

Previous
From: Fran Fabrizio
Date:
Subject: Slightly OT: outer joins
Next
From: Doug McNaught
Date:
Subject: Re: A newbie's opinion - postgres NEEDS a Windows binary!