0

We have migrated our PROD DB to new server with 24GB RAM.

Based on that value it is possible to tune some PG configuration values?

I think we can increase some values.

Is it possible to suggest which value can be increased like shared_buffers to 50% of RAM, etc?

Improve this question
1
  • Without knowing basics like OLAP/OLTP and many other important factors, advice is impossible to purvey!
    – Vérace
    Commented Aug 22 at 11:36

1 Answer 1

Reset to default
0

https://pgtune.leopard.in.ua/ if you want a formula. Consider though that proper parameter tuning can only be done by continuously observing the system metrics and determining the bottleneck(s).

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.