Hi,
On 2018-04-26 15:08:24 -0400, Robert Haas wrote:
> I don't think that's a very useful suggestion. Changing
> N_RELEXTLOCK_ENTS requires a recompile, which is going to be
> impractical for most users. Even if we made it a GUC, we don't want
> users to have to tune stuff like this. If we actually think this is
> going to be a problem, we'd probably better rethink the desgin.
Agreed.
> I think the real question is whether the scenario is common enough to
> worry about. In practice, you'd have to be extremely unlucky to be
> doing many bulk loads at the same time that all happened to hash to
> the same bucket.
With a bunch of parallel bulkloads into partitioned tables that really
doesn't seem that unlikely?
Greetings,
Andres Freund