If this is the same posting made to perlmonks, my comment there also applies here.
If you are inserting 50,000 records rapidly with Pg, *you must* use transactions. Begin a transaction block, insert 1000 records, and commit it. repeat until done. Otherwise, Pg wraps EACH AND EVERY insert in a transaction block, and you rapidly go into thrash and slowdown mode. -- Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 <[EMAIL PROTECTED]> <URL:http://www.stonehenge.com/merlyn/> Perl/Unix/security consulting, Technical writing, Comedy, etc. etc. See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training! -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
