Re: dbt2 NOTPM numbers

Поиск
Список
Период
Сортировка
От Markus Schiltknecht
Тема Re: dbt2 NOTPM numbers
Дата
Msg-id 4665725D.6060102@bluegap.ch
обсуждение исходный текст
Ответ на Re: dbt2 NOTPM numbers  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-performance
Hi,

Heikki Linnakangas wrote:
> Maybe, TPC-C is very write-intensive. I don't know much about RAID
> stuff, but I think you'd really benefit from a separate WAL drive. You
> could try turning fsync=off to see if that makes a difference.

Hm.. good idea, I'll try that.

> Oh, and how many connections are you using? DBT-2 can be quite sensitive
> to that. 30 seems to work pretty well for me.

I've been using between 2 and 90, but that made pretty much no
difference at all. I'm not getting anything more that some 300 NOTPM.

Regards

Markus

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

Предыдущее
От: Douglas J Hunley
Дата:
Сообщение: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Следующее
От: Douglas J Hunley
Дата:
Сообщение: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x