On Fri, Dec 17, 2010 at 07:48, selvi88
<selvi.dct@gmail.com> wrote:
My requirement is more than 15 thousand queries will run,
It will be 5000 updates and 5000 insert and rest will be select.
What IO system are you running Postgres on? With that kind of writes you should be really focusing on your storage solution.
Each query will be executed in each psql client, (let say for 15000 queries
15000 thousand psql connections will be made).
You will benefit from a connection pooler. Try fiddling with maximum_connections till you hit a sweet spot. Probably you should start with 20 connections and go up till you see your tps decrease.
Still, without deeply looking into your storage I wonder if you'll ever reach your TPS objective.