On Thu, Aug 25, 2016 at 12:59 PM, Peter Geoghegan <p...@heroku.com> wrote: > Maybe we should change the ordering of those IndexInfo structs to > something more suitable, but it must be immutable (it cannot hinge > upon the details of one particular DML statement).
I meant that it must be stable (not immutable), in the specific sense that it cannot change without an ALTER TABLE or similar. The order of insertion should be consistent among all backends that might be performing DML against the table at any given time, since, in general, to do otherwise risks deadlocking (perhaps only with hash indexes, or a much earlier version of the nbtree am that still used heavyweight locks). -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
