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.

Regards,
Junaid


(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 revsys.com. You may also suggest good article regarding Postgres server performance.

Regards,
Junaid