Postgres related parameter change

General
1

Hi
I am using YSQL, 3 node cluster. Just want to ask if i wish to increase postgres related values like shared buffer, work mem, temp buffer, temp file limit.

  1. How to change these values for entire cluster?
  2. Do I need to change these values in every node?
  3. Can I increase max connections beyond 300 in every node?
  4. After changing these values do I need to restart?
    Thanking you in advance for your help.
2

Hi @subh14

Please don’t post the same question in multiple places at the same time (also posted on slack at the same time).

There are several ways to change them yb-tserver configuration reference | YugabyteDB Docs

You can with yb-tserver configuration reference | YugabyteDB Docs, but it’s usually an anti-pattern to need that many connections, you should use a connection pooler in your app and maybe an external one.

3

Hi dorian
my apologies, thank you for your response.