Gregory Stark <st...@enterprisedb.com> writes:
> Marinos Yannikos <m...@pobox.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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
