Re: [GENERAL] Performance UPDATE/INSERT

[codeWarrior]

Turn off your indices on the table... do the inserts... do the updates... rebuild the indices....       ""MG"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... Hello,   I have about 100 000 records, which need about 30 minutes to write them with single INSERTs into PostgreSQL. If I go through these 100 000 records and make an UPDATE on each record, it takes 1 hour.   Can anyone tell me, about his experience of the performance of INSERT and UPDATE.   Greetings Michaela