Re: CLUSTER cannot complete

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