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)
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 |