| 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: | AANLkTi=yEam8XMoOUj9nfizew=rsB3nhjyCEnY2wW_qF@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-12-20 17:26:56 | Re: postgres performance tunning |
| Previous Message | Kenneth Marshall | 2010-12-20 15:48:47 | Re: CPU bound |