Skip site navigation (1) Skip section navigation (2)

Re: postgres performance tunning

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: selvi88 <selvi(dot)dct(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgres performance tunning
Date: 2010-12-17 13:20:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
selvi88 wrote:
>         I have a requirement for running more that 15000 queries per second.
> Can you please tell what all are the postgres parameters needs to be changed
> to achieve this. 
>         Already I have 17GB RAM and dual core processor and this machine is
> dedicated for database operation. 

You can find a parameter tuning guide at that may 
help you out.

You are unlikely to hit 15K queries/second with a dual core processor.  
When I run really trivial queries using the pgbench program to simulate 
database activity, that normally gives about 7K queries/second/core.  My 
dual-core laptop will do 13K/second for example.  And real-world queries 
tend to be a bit more intensive than that.  I would normally expect that 
a quad-core system would be needed to reach 15K even with trivial 
queries; my quad-core server at home will do 28K queries/second running 
pgbench.  If your individual cores are really fast, you might just make it.

Greg Smith   2ndQuadrant US    greg(at)2ndQuadrant(dot)com   Baltimore, MD
PostgreSQL Training, Services and Support
"PostgreSQL 9.0 High Performance":

In response to


pgsql-performance by date

Next:From: Nick MathesonDate: 2010-12-17 13:51:27
Subject: Re: Help with bulk read performance
Previous:From: selvi88Date: 2010-12-17 10:48:42
Subject: Re: postgres performance tunning

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group