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

Re: postgres performance tunning

From: Fernando Hevia <fhevia(at)gmail(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-20 15:50:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Fri, Dec 17, 2010 at 07:48, selvi88 <selvi(dot)dct(at)gmail(dot)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.

In response to

pgsql-performance by date

Next:From: Scott MarloweDate: 2010-12-20 17:26:56
Subject: Re: postgres performance tunning
Previous:From: Kenneth MarshallDate: 2010-12-20 15:48:47
Subject: Re: CPU bound

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