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: (view raw or whole 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

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-2015 The PostgreSQL Global Development Group