Jon Nelson <jnelson+pgsql@xxxxxxxxxxx> writes: > What would the effect be of patching postgresql to allow indexes to > see and follow the HOT chains during index creation? It would break things. We did a *lot* of thinking about this when HOT was implemented; there are not simple improvements to be made. The particular case you have here might be improvable because you actually don't have any indexes at all during the UPDATE, and so maybe there's no need for it to create HOT-update chains. But that would still fall over if you made an index, did the update, then made more indexes. > Is this "HOT update" optimization interaction with indexes documented > anywhere? It doesn't appear to be common knowledge as there are now 20 > messages in this topic and this is the first mention of the HOT > updates / index interaction. The reason it wasn't mentioned before was that you kept on not showing us what you did, and there was no reason for anyone to guess that you were mixing updates and index creations in a single transaction. We have seen people run into this type of issue once or twice since 8.3 came out, but it's sufficiently uncommon that it doesn't spend time at the front of anybody's mind. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
