Re: Bulk inserts within a Perl script? - Mailing list pgsql-general

From Tom Lane
Subject Re: Bulk inserts within a Perl script?
Date
Msg-id 19883.1145402097@sss.pgh.pa.us
Whole thread Raw
In response to Bulk inserts within a Perl script?  ("Kynn Jones" <kynnjo@gmail.com>)
List pgsql-general
"Kynn Jones" <kynnjo@gmail.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

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Bulk inserts within a Perl script?
Next
From: Teodor Sigaev
Date:
Subject: Re: Bulk inserts within a Perl script?