Re: Potential problem with HOT and indexes?

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Postgres <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Potential problem with HOT and indexes?
Date: 2009-03-08 17:45:53
Message-ID: 87d4cr9acu.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Gregory Stark <stark(at)enterprisedb(dot)com> writes:
>> Another thought now though. What if someone updates the pg_index entry --
>> since we never reset indcheckxmin then the new tuple will have a new xmin and
>> will suddenly become invisible again for no reason.
>
> Hmm ... if updates to pg_index entries were common then I could get
> worried about that, but they really aren't.

Fixing this for REINDEX is fairly straightforward I think. It already updates
the pg_index line to fix indisvalid and indisready. see:

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Asko Oja 2009-03-08 18:50:01 Re: Out parameters handling
Previous Message Tom Lane 2009-03-08 17:36:08 Re: Potential problem with HOT and indexes?