Postgres Pro
Downloads
Home   >   mailing lists

Best method for large updates - Mailing list pgsql-novice

From Francisco Reyes
Subject Best method for large updates
Date
Msg-id Pine.BSF.4.32.0102020306420.2785-100000@zoraida.reyes.somos.net
Whole thread Raw
List pgsql-novice
Tree view 
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:

Previous
From: "Michael Miyabara-McCaskey"
Date:
Subject: RE: Sizing of LARGE databases.
Next
From: Herb Pabst
Date:
Subject: php4 mod for apache...