Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD
Дата
Msg-id 20140422.095806.418640596629159403.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD  (Tatsuo Ishii <ishii@postgresql.org>)
Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
> * Tatsuo Ishii (ishii@postgresql.org) wrote:
>> I observe performance degradation with PostgreSQL 9.3 vs 9.2 on Linux
>> as well.  The hardware is HP DL980G7, 80 cores, 2TB mem, RHEL 6,
>> pgbench is used (read only query), scale factor is 1,000 (DB size
>> 15GB).
> 
> Can you isolate the sysv-vs-mmap patch and see what happens with just
> that change..?

Unfortunately I don't have an access to the machine at this moment.

>> Included is the graph (from PostgreSQL Enterprise Consortium's 2014
>> report page 13: https://www.pgecons.org/downloads/43). I see up to 14%
>> degration (at 128 concurrent users) comparing with 9.2.
> 
> That URL returns 'Forbidden'...

Sorry for this. I sent a problem report to the person in charge.  In
the mean time, please go to:
https://www.pgecons.org/download/works_2013/ then click the link "2013
年度WG1活動報告" (sorry for not English). You should be able to
download a report (PDF).

Also the report is written in Japanese. I hope you can read at leat
the graph in page 13 and the table in page 14.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Clock sweep not caching enough B-Tree leaf pages?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Clock sweep not caching enough B-Tree leaf pages?