Re: postgres & smp

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

t

--
thomas(dot)graichen(at)innominate(dot)com
innominate AG
the linux architects
tel: +49-30-308806-13 fax: -77 http://www.innominate.com