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.
- 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?
Thanking you in advance for your help.
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.
my apologies, thank you for your response.