Re: (some) Indexes ignored after long-running UPDATE and REINDEX at the same time (8.3.6)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Marinos Yannikos <mjy(at)pobox(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: (some) Indexes ignored after long-running UPDATE and REINDEX at the same time (8.3.6)
Date: 2009-03-08 16:47:15
Message-ID: 29499.1236530835@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gregory Stark 2009-03-08 17:24:18 Re: (some) Indexes ignored after long-running UPDATE and REINDEX at the same time (8.3.6)
Previous Message Gregory Stark 2009-03-08 12:51:38 Re: (some) Indexes ignored after long-running UPDATE and REINDEX at the same time (8.3.6)