Re: CLUSTER cannot complete

[Greg Smith <greg@xxxxxxxxxxxxxxx>]

Vick Khera wrote:

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