Is there anything in Postgres that would allow me to insert a whole bunch
of rows at once, with a single insert or do a prefetch? Here is my
problem:


my $dbh = DBI->connect("dbi:Oracle:$db", $username, $passwd)
$dbh->{RaiseError} = 1;
$dbh->{ora_check_sql} = 0;
$dbh->{RowCacheSize} = 1024;
$dbh->{ora_array_chunk_size} = 1024;
return ($dbh);

This snippet tells Oracle to try fetching 1024 rows at once. I can also
do array binds and array executions, to send multiple rows to be
processed by a single insert. Is there anything even remotely similar
in the Postgres world? I was unable to find anything in the DBI driver
documentation, I wonder whether there are any parameters to twist, either
on the linux itself, or in the postgres.conf, that could help me with
that.


--
http://mgogala.byethost5.com

Mladen Gogala, 26.08.2010 00:11:
INSERT INTO my_table
(col1, col2, col3)
VALUES
(1,2,3),
(4,5,6),
(7,8,9);

will insert three rows.

Regards
Thomas

On Thu, 26 Aug 2010 08:30:05 +0200, Thomas Kellerer wrote:

Excellent. I will test the array bind and see whether there is any
difference in performance.



--
http://mgogala.byethost5.com