Re: postgres & smp

Поиск
Список
Период
Сортировка
От Thomas Graichen
Тема Re: postgres & smp
Дата
Msg-id news2mail-96pbe7$omh$1@mate.bln.innominate.de
обсуждение исходный текст
Ответ на postgres & smp  (Thomas Graichen <news-list.pgsql.admin@innominate.de>)
Ответы Re: postgres & smp  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: v7.1b4 bad performance
Следующее
От: Dmitry Morozovsky
Дата:
Сообщение: Re: v7.1b4 bad performance