Re: Bulk inserts within a Perl script?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kynn Jones" <kynnjo(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bulk inserts within a Perl script?
Date: 2006-04-18 23:14:57
Message-ID: 19883.1145402097@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Kynn Jones" <kynnjo(at)gmail(dot)com> writes:
> So I'm back at the drawing board. How can I make fast bulk inserts into a
> PostgreSQL database from within a Perl script?

The simplest and most effective thing you can do is to wrap many inserts
into a single transaction block. After that, if you're using a driver
that has "real" prepared statement support, setting up a prepared
INSERT statement should help some.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Sigaev 2006-04-18 23:54:34 Re: Bulk inserts within a Perl script?
Previous Message Steve Atkins 2006-04-18 23:14:03 Re: Bulk inserts within a Perl script?