|[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]|
On 06/25/2012 11:00 PM, Radovan Jablonovsky wrote:
I can't explain why it was topping out at 85 when it was set to 600, but - I strongly recommend that you switch to a connection pool and lower your max_connections considerably. You'll likely get much better performance with max connections at 20 or less - the usual rule of thumb is "num_hdds + num_cpus" but in reality you need to benchmark and tune to work out what's best.
pgbouncer is a good light-weight pooling option.
[Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite]