On Fri, Mar 15, 2019 at 9:48 AM Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> 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: > > https://doxygen.postgresql.org/autovacuum_8c.html 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: > > https://www.postgresql.org/docs/11/logical-replication-security.html > > But I am speaking of pglogical, which does require superuser, last I checked :). <adrian.kla...@aklaver.com> It does use replication slots, but there are processes corresponding to each subscription. I have some databases with dozens of them. Thanks, Jeremy
