Thread: Initial performance tuning question
Hello,
I am setting up a PostgreSQL instance in the cloud for a customer and a couple of months ago I couldn't spell PostgreSQL.
I have a few questions:
What should I look for in the way of performance tuning/how should I set it up? RHEL and CentOS will be used. RAM...probably between 3-4G. I'm not sure about the storage type. As for what I'm tuning...I'm more interested in response times than transactions per second. Could I create a script to automate the performance tuning?
What should I look for in the way of performance tuning/how should I set it up? RHEL and CentOS will be used. RAM...probably between 3-4G. I'm not sure about the storage type. As for what I'm tuning...I'm more interested in response times than transactions per second. Could I create a script to automate the performance tuning?
Also. I'm looking at Tenable's PostgreSQL 9.1 Best Practices DB and PostgreSQL 9.1 Best Practices Unix OS, what should I look for in the way of hardening/how should I set it up?
Thank you for any help and/or suggestions!
> Lawrence Wetsel <trey_wetsel@mac.com> hat am 15. März 2016 um 20:43 > geschrieben: > > > > Hello, > > > > I am setting up a PostgreSQL instance in the cloud for a customer and a couple > of months ago I couldn't spell PostgreSQL. > > > > I have a few questions: > > What should I look for in the way of performance tuning/how should I set it > up? RHEL and CentOS will be used. RAM...probably between 3-4G. I'm not sure > about the storage type. As for what I'm tuning...I'm more interested in > response times than transactions per second. Could I create a script to > automate the performance tuning? > As a rule of thumb you can set shared_buffers to 1/4 of RAM, and you can / should increase work_mem from default 4M to more, maybe 16M or so, but that depends on your workload. There is more, but that depends all on your workload. -- Andreas Kretschmer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services