On 3/14/19 8:23 AM, Jeremy Finzel wrote: > I don't find a clear mention in the docs of superuser processes that are > exempt from counting toward superuser_reserved_connections. So I would > think that it's possible that postgres autovac workers ought to count > toward that. Am I wrong about that? I actually have the same question
AFAICK autovacuum workers do not use the connections referred to above. The details can be found here:
Not sure I can really grok that and how it answers the question. Are you saying if you have max_connections set to 10, you could theoretically have 20 autovac processes still?
> about pglogical replication background workers and manager, which also > run as postgres.
But the actual connection can be by a different user: