Kevin Grittner <kgrittn(at)ymail(dot)com> writes:
> OK. I had seen that no locks were held after the insert and wasn't
> aware that we acquired and then released them for each insert
> within a transaction. On the other hand, we acquire locks on all
> indexes even for a HOT UPDATE which uses a seqscan, and hold those
> until end of transaction. Is there a reason for that?
Sounds dubious to me; although in the HOT code it might be that there's
no convenient place to release the index locks.
regards, tom lane