Re: postgres & smp

Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Thomas Graichen <news-list.pgsql.admin@innominate.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.graichen@innominate.com
                                                         innominate AG
                                                  the linux architects
tel: +49-30-308806-13   fax: -77             http://www.innominate.com