Alvaro Herrera wrote: > Tom Lane wrote: > > Alvaro Herrera <alvhe...@2ndquadrant.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers