Re: performance config help

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Bob Dusek" <redusek(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance config help
Date: 2010-01-11 17:17:53
Message-ID: 4B4B08E1020000250002E185@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Bob Dusek <redusek(at)gmail(dot)com> wrote:
> Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:
>> Bob Dusek <redusek(at)gmail(dot)com> wrote:

>>> 4X E7420 Xeon, Four cores (for a total of 16 cores)

>> What method of striped RAID?
>
> RAID-0

I hope you have a plan for what to do when any one drive in this
array fails, and the entire array is unusable.

Anyway, my benchmarks tend to show that best throughput occurs at
about (CPU_count * 2) plus effective_spindle_count. Since you seem
to be fully cached, effective_spindle_count would be zero, so I
would expect performance to start to degrade when you have more than
about 32 sessions active.

> We actually see degredation when we get more than 40 concurrent
> requests.

Close enough.

> when we run 200+ requests, we see multi-second queries.

No surprise there. Your vmstat output suggests that context
switches are becoming a problem, and I wouldn't be surprised if I
heard that the network is an issue. You might want to have someone
take a look at the network side to check.

You want to use some connection pooling which queues requests when
more than some configurable number of connections is already active
with a request. You probably want to run that on the server side.
As for the postgresql.conf, could you show what you have right now,
excluding all comments?

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ivan Voras 2010-01-11 17:19:40 Re: performance config help
Previous Message Ivan Voras 2010-01-11 17:12:59 Re: performance config help