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

Re: High context switches occurring

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Anjan Dave <adave(at)vantage(dot)com>, Vivek Khera <vivek(at)khera(dot)org>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: High context switches occurring
Date: 2005-12-20 14:41:30
Message-ID: 28871.1135089690@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Oleg Bartunov <oleg(at)sai(dot)msu(dot)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(at)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

In response to

Responses

pgsql-performance by date

Next:From: David RousselDate: 2005-12-20 15:00:30
Subject: Re: 2 phase commit: performance implications?
Previous:From: David RousselDate: 2005-12-20 13:26:00
Subject: Re: filesystem performance with lots of files

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