Vick Khera wrote:
On Mon, Feb 15, 2010 at 9:54 AM, Marcin Krol <mrk...@gmail.com> wrote:
I didn't add or delete many rows from that table. Quite a lot of UPDATEs are
running daily, though.
Every update is equal to insert + delete, except in certain
circumstances in 8.3 and above.
Well, it's still an insert + delete of the actual data row itself even
in 8.3, the later versions just optimize how that impacts the index
related changes there better.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
