Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> Marinos Yannikos <mjy(at)pobox(dot)com> writes:
>> I had a strange problem this morning - I started a long-running UPDATE on a
>> heavily indexed table with about 8m rows last night to test a trigger-based
>> queue (PgQ):
> I think you were bitten by a gotcha with newly created indexes and "heap-only"
> updates.
This would only be possible if it were 8.3 and the reindex script used
REINDEX CONCURRENTLY. Neither fact is in evidence at this point.
regards, tom lane