Tom Lane writes:
> Gregory Stark writes:
>> Marinos Yannikos 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 new
Gregory Stark writes:
> Marinos Yannikos 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 "hea
Marinos Yannikos writes:
> Hi,
>
> 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):
>
> UPDATE eintrag SET mtime=mtime;
I think you were bitten by a gotcha with newly created i
Hi,
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):
UPDATE eintrag SET mtime=mtime;
This took about 12 hours, during this time our nightly REINDEX script
ran (successfully).
