Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group