Postgres related parameter change

[subh14]

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.

[dorian_yugabyte]

Hi @subh14

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

@subh14

• How to change these values for entire cluster?
• Do I need to change these values in every node?
• Can I increase max connections beyond 300 in every node?
• After changing these values do I need to restart?

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

@subh14

Can I increase max connections beyond 300 in every node?

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.

[subh14]

Hi dorian
my apologies, thank you for your response.