Performance UPDATE/INSERT

From: "MG" <pgsql-general(at)carladata(dot)de>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Performance UPDATE/INSERT
Date: 2006-04-11 09:08:57
Message-ID: 006701c65d47$90af8140$340aa8c0@geisslinger
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2006-04-11 09:20:32 Re: Performance UPDATE/INSERT
Previous Message Daniel Tourde 2006-04-11 08:24:30 How to import a CSV file (originally from Excel) into a Postgresql 8.0.7 database