# Postgres related parameter change

**URL:** <https://forum.yugabyte.com/t/postgres-related-parameter-change/2447>\
**Category:** General\
**Created:** [January 18, 2024, 2:59pm UTC](https://forum.yugabyte.com/t/postgres-related-parameter-change/2447 "2024-01-18T14:59:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![subh14](https://avatars.discourse-cdn.com/v4/letter/s/958977/32.png) [@subh14](https://forum.yugabyte.com/u/subh14)\
**Post date:** [January 18, 2024, 2:59pm UTC](https://forum.yugabyte.com/t/postgres-related-parameter-change/2447/1 "2024-01-18T14:59:14Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)\
**Post date:** [January 18, 2024, 4:36pm UTC](https://forum.yugabyte.com/t/postgres-related-parameter-change/2447/2 "2024-01-18T16:36:51Z")

</div>

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](https://docs.yugabyte.com/preview/reference/configuration/yb-tserver/#postgresql-server-options)

> [@subh14](#):
>
> Can I increase max connections beyond 300 in every node?

You can with [yb-tserver configuration reference | YugabyteDB Docs](https://docs.yugabyte.com/preview/reference/configuration/yb-tserver/#ysql-max-connections), 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.

---

<div class="post-metadata">

**Author:** ![subh14](https://avatars.discourse-cdn.com/v4/letter/s/958977/32.png) [@subh14](https://forum.yugabyte.com/u/subh14)\
**Post date:** [January 18, 2024, 5:25pm UTC](https://forum.yugabyte.com/t/postgres-related-parameter-change/2447/3 "2024-01-18T17:25:04Z")

</div>

Hi dorian  
my apologies, thank you for your response.