PostgreSQL Optimal configurations

(Junaid Mailk) #1

Hello Everyone,

We are planning to deploy Discourse on our dedicated server. Can anyone share Optimal setting of PostgreSQL Configurations.


(Matt Palmer) #2

Our recommendations are encoded in the discourse-setup script; further tuning should be done by a suitably experienced DBA with reference to your exact workload and the hardware being used.

(Jeff Atwood) #3

In general you want a ton of memory. This is quite universal across all databases. Read the relevant docs for more info, but that is the biggest db performance factor by far.

(Junaid Mailk) #4

Thank you very much, it was helpful.

(Junaid Mailk) #5

I also followed the guideline added here You may also suggest good article regarding Postgres server performance.