Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Thomas Graichen <news-list(dot)pgsql(dot)admin(at)innominate(dot)de> writes:
>> i hope this list is somewhat the right one for this ...
>> i did some small tests with postgresql-71.beta4 on various
>> filesystems (ext2, reiserfs, xfs) on two machines: 1 single
>> cpu and one 2 cpu smp and was a bit surprised to see the tps
>> results of the smp case to be lower than the one of the up case
> Hm, did you set commit_delay to zero? What are the other postmaster
> parameters (especially -B) ?
i used 32 clients -N set to 128 and -B to 256 - commit_delay was
set to 5 (default) - do you expect much better smp results with
commit_delay=0? what exaclty does commit_delay=0 mean or where
can i find docs about this (and some of the other new parameters)?
again - a lot of thanks in advance
the linux architects
tel: +49-30-308806-13 fax: -77 http://www.innominate.com
In response to
pgsql-admin by date
|Next:||From: Dmitry Morozovsky||Date: 2001-02-18 20:32:11|
|Subject: Re: v7.1b4 bad performance |
|Previous:||From: Bruce Momjian||Date: 2001-02-18 19:59:40|
|Subject: Re: v7.1b4 bad performance|