""MG"" <pgsql-general@xxxxxxxxxxxx> wrote in message 006701c65d47$90af8140$340aa8c0@geisslinger">news:006701c65d47$90af8140$340aa8c0@geisslinger... 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