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?
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?