Performance UPDATE/INSERT - Mailing list pgsql-general

From MG
Subject Performance UPDATE/INSERT
Date
Msg-id 006701c65d47$90af8140$340aa8c0@geisslinger
Whole thread Raw
Responses Re: Performance UPDATE/INSERT
Re: Performance UPDATE/INSERT
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: installing and using autodoc
Next
From: "A. Kretschmer"
Date:
Subject: Re: Performance UPDATE/INSERT