Alvaro Herrera wrote:
> Well, there certainly is locking involved in inserting index entries,
> but it's more fine-grained than you seem to think. Only one page of the
> index is locked at any time, resulting in that typically there's very
> little blocking involved. Two processes can be inserting into the same
> index concurrently (btree and GiST indexes at least; GiST only gained
> concurrency in a recent release, I don't remember if it was 8.0 or 8.1).
Thank you, this was the bit I was missing. In retrospect, I don't really
know how I came to conclusion the whole index was being locked :(