From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org, pavan(dot)deolasee(at)gmail(dot)com |
Subject: | Re: [COMMITTERS] pgsql: Release note updates. |
Date: | 2017-02-07 15:59:31 |
Message-ID: | 20170207155931.vgzv5umuyfvp4bqz@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
Alvaro Herrera wrote:
> Tom Lane wrote:
> > Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
>
> > > May I suggest
> >
> > > + If <command>CREATE INDEX CONCURRENTLY</> was used to build an index
> > > + that depends on a column not previously indexed, then rows
> > > + updated by transactions that ran concurrently with
> > > + the <command>CREATE INDEX</> command could have missed receiving
> > > + index entries.
> >
> > Can we say "pre-existing rows that were updated by...", or is that
> > too optimistic?
>
> Hmm. Now that I think about it, it is probably possible to have a
> transaction started before CIC that inserted a bunch of rows, and then
> runs the UPDATE during the CIC race window. Maybe there's a reason the
> bug wouldn't hit in that case but I don't see it, and I'm not able to
> test it right now to verify.
Pavan adds that it's possible to have a transaction do INSERT while CIC
is running, then some other transaction executes the UPDATE.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2017-02-07 17:40:39 | pgsql: Cache hash index's metapage in rel->rd_amcache. |
Previous Message | Tom Lane | 2017-02-07 15:28:15 | Re: [COMMITTERS] pgsql: Release note updates. |
From | Date | Subject | |
---|---|---|---|
Next Message | Joel Jacobson | 2017-02-07 16:16:51 | Re: Idea on how to simplify comparing two sets |
Previous Message | Tom Lane | 2017-02-07 15:58:41 | Re: Idea on how to simplify comparing two sets |