Best method for large updates

From: Francisco Reyes <lists(at)reyes(dot)somos(dot)net>
To: Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Best method for large updates
Date: 2001-02-02 08:09:34
Message-ID: Pine.BSF.4.32.0102020306420.2785-100000@zoraida.reyes.somos.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

When doing large updates which approach is better:

1- Delete all rows which exist and that will be updated. Insert all new
data.

2- Process updates for all existing data, merge new data.

Browse pgsql-novice by date

  From Date Subject
Next Message Herb Pabst 2001-02-02 17:03:08 php4 mod for apache...
Previous Message Francisco Reyes 2001-02-02 06:19:40 Re: [NOVICE] RE: Sizing of LARGE databases.