max_connections

From: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: max_connections
Date: 2021-05-30 14:49:54
Message-ID: CAM+6J96Fpz=Op3Q=SVzgRbNmcarEcSL9asi8ObDxzPKNQCOx1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a two dumb questions.

1)
I know the max_connections value change requires a restart.

I also read a thread, which says why it is the case, assuming it still
holds true.

Jean Arnaud <Jean(dot)Arnaud(at)inrialpes(dot)fr> writes:
> I'm looking for a way to change the "max_connections" parameter without
> restarting the PostGreSQL database.

There is none. That's one of the parameters that determines shared
memory array sizes, and we can't change those on-the-fly.

regards, tom lane

Does that mean, if I set max_connections to 1000 users, but only intend to
use 10 at max (via conn limit per role settings), what would be the perf
difference compared to max_connections = 100 , but still using only 10 at
max.

2)
can i for test purposes.compile src with a xid max value to 2^16 etc ? like
with uint16

Basically, I was trying to simulate xid wraparound, by creating an open
transaction and an inactive replication slot, and then running a huge
parallel loops to bump txid_current() to see what happens at 2B crossover.
it takes forever on my slow laptop.
I do not see these in test scenarios, or could not find any.

as always, ignore if not relevant, or already discussed.
I am preparing for interviews, hence asking myself dumb questions :)

--
Thanks,
Vijay
Mumbai, India

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Willy-Bas Loos 2021-05-31 13:54:56 Re: WAL accumulating, Logical Replication pg 13
Previous Message Dean Gibson (DB Administrator) 2021-05-29 22:47:39 Re: AWS forcing PG upgrade from v9.6 a disaster