Performance Question

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Performance Question
Date: 2006-06-14 19:57:37
Message-ID: 200606141557.37321.terry@esc1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello List:

I've been told that an update to a record is equivalent to a delete and insert
operation. We have a utility written in Perl that brings into sync certain
elements of 50 thousand records on 8 structurally identical databases. We
threw together the script and decided to just delete the record and re-insert
it with the data that was brought into sync. Now the question: Is it just as
fast to do it this way, or is there some hidden advantage to performing an
update?

Just curious.

TIA

master=# select version();
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
20030502 (Red Hat Linux 3.2.3-49)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2006-06-14 20:21:33 Re: Performance Question
Previous Message Milen Kulev 2006-06-14 19:44:40 Re: Partitioning... -> solved