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
pgsql-performance by date
|Next:||From: David Roussel||Date: 2005-12-20 15:00:30|
|Subject: Re: 2 phase commit: performance implications?|
|Previous:||From: David Roussel||Date: 2005-12-20 13:26:00|
|Subject: Re: filesystem performance with lots of files|