Turn off your indices on the table... do the inserts... do the updates... rebuild the indices....
""MG"" <pgsql-general(at)carladata(dot)de> wrote in message news:006701c65d47$90af8140$340aa8c0(at)geisslinger(dot)(dot)(dot)
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