Vick Khera wrote:
On Mon, Feb 15, 2010 at 9:54 AM, Marcin Krol <mrkafk@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
greg@2ndQuadrant.com www.2ndQuadrant.us