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

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