pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Oleg Bartunov <oleg@sai.msu.su>
Cc: Anjan Dave <adave@vantage.com>
Cc: Vivek Khera <vivek@khera.org>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: High context switches occurring
Date: Tue, 20 Dec 2005 09:41:30 -0500
Message-ID: <28871.1135089690@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.GSO.4.63.0512200822360.13553@ra.sai.msu.su>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098F14@vt-pe2550-001.vantage.vantage.com>
	<Pine.GSO.4.63.0512200822360.13553@ra.sai.msu.su>

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



view thread (29+ messages)  latest in thread

Message-ID: <28871.1135089690@sss.pgh.pa.us>
Permalink:  ../28871.1135089690@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/28871.1135089690@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, oleg@sai.msu.su, adave@vantage.com, vivek@khera.org
  Subject: Re: High context switches occurring
  In-Reply-To: <28871.1135089690@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox