Re: [SQL] postgresql multiple insert slow

2004-06-06 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, "Michael L. Hostbaek" <[EMAIL PROTECTED]> writes: > Hello, > I've got a table in an oracle database with approx. 10 records, that > I'd like to put into a table in a postgresql database. (This should be > done a couple of times per week) > I have written a sho

[SQL] postgresql multiple insert slow

2004-06-05 Thread Michael L. Hostbaek
Hello, I've got a table in an oracle database with approx. 10 records, that I'd like to put into a table in a postgresql database. (This should be done a couple of times per week) I have written a short perl script, on a server that has remote access to both the oracle database as well as t

Re: [SQL] postgresql multiple insert slow

2004-02-21 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] ("Michael L. Hostbaek") would write: > I runs fine - and I get no errors - but it takes almost 25 minutes to > complete.. I tried running the script while just grabbing the rows from > the oracle database and writing to a text file - and th

Re: [SQL] postgresql multiple insert slow

2004-02-21 Thread Tom Lane
"Michael L. Hostbaek" <[EMAIL PROTECTED]> writes: > I runs fine - and I get no errors - but it takes almost 25 minutes to > complete.. I tried running the script while just grabbing the rows from > the oracle database and writing to a text file - and then it only takes > a couple of minutes .. So i