Gregory Stark <[email protected]> writes:
> Marinos Yannikos <[email protected]> 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
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
