Re: update/insert,

From: "Zeugswetter Andreas DCP SD" <ZeugswetterA(at)spardat(dot)at>
To: "Mark Woodward" <pgsql(at)mohawksoft(dot)com>, "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
Cc: "Zdenek Kotala" <zdenek(dot)kotala(at)sun(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: update/insert,
Date: 2006-07-05 14:59:52
Message-ID: E1539E0ED7043848906A8FF995BDA579011F0B88@m0143.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> OK, but the point of the question is that constantly updating
> a single row steadily degrades performance, would
> delete/insery also do the same?

Yes, there is currently no difference (so you should do the update).
Of course performance only degrades if vaccuum is not setup correctly.

Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mark 2006-07-05 15:25:18 Re: update/insert,
Previous Message Mark Woodward 2006-07-05 14:45:35 Re: update/insert,