Re: High context switches occurring - Mailing list pgsql-performance

From Tom Lane
Subject Re: High context switches occurring
Date
Msg-id 28871.1135089690@sss.pgh.pa.us
Whole thread Raw
In response to Re: High context switches occurring  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: High context switches occurring  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-performance
Oleg Bartunov <oleg@sai.msu.su> writes:
> I see a very low performance and high context switches on our
> dual itanium2 slackware box (Linux ptah 2.6.14 #1 SMP)
> with 8Gb of RAM, running 8.1_STABLE. Any tips here ?

> postgres@ptah:~/cvs/8.1/pgsql/contrib/pgbench$ time pgbench -s 10 -c 10 -t 3000 pgbench
> starting vacuum...end.
> transaction type: TPC-B (sort of)
> scaling factor: 1
> number of clients: 10

You can't expect any different with more clients than scaling factor :-(.

Note that -s is only effective when supplied with -i; it's basically
ignored during an actual test run.

            regards, tom lane

pgsql-performance by date:

Previous
From: David Roussel
Date:
Subject: Re: filesystem performance with lots of files
Next
From: David Roussel
Date:
Subject: Re: 2 phase commit: performance implications?