Greg Stark <gsstark@mit.edu> writes:
> Hm, so hypothetically an insert or update on a table with 4 indexes which have
> been split into 4 partitions would need to touch each partition?
That would be the best case, actually, that each heavily-used lock ends
up in a different partition. As Simon points out, we have no way to
guarantee that.
> Would that defeat the benefits of the partitioning? Or enhance it?
It'd be what you'd want, because it would reduce the odds that two
processes doing this concurrently would need to touch the same partition
at the same time.
regards, tom lane