> did you read > http://www.postgresql.org/docs/8.2/static/kernel-resources.html ? Yes, I read. But I'm not able to find a correct way to increase Linux Kernel parameters. > If it is a dedicated DB server the rule of thumb usually is to use > 25% RAM for shared buffers, but no more than 8GB unless proper > benchmarking has shown a benefit using above 8GB. But I am not > sure if 8GB of shared buffers is suitable for 8.2 at all. 8.2 is EOL btw. > Also set effective cache size to 50% RAM. As you can see, in my case, I'm setting only 3 GB (3072 MB), which is actually below 8 GB. So, I need to increase kernel parameters in this case. Any ideas/insights? > Also, do you really NEED 1000 concurrent sessions? IF you really do, it might > be worse to look into a connection pooler. Yes, our web-based application has crossed more than 500 concurrent users. Hence we've already upgraded RAM and now we want to upgrade max connection parameter too. Yes, we're already using pgpool-II v3.1.1 for connection pooling. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
