Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD
Дата
Msg-id CAB7nPqSHaVq1jbLKS901bg_Ctg+WuZwx=Xa=mDfu4TAU=CpRgA@mail.gmail.com
обсуждение исходный текст
Ответ на 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  (Tatsuo Ishii <ishii@postgresql.org>)
Список pgsql-hackers
<div dir="ltr"><br /><div class="gmail_extra"><br /><br /><div class="gmail_quote">On Tue, Apr 22, 2014 at 9:58 AM,
TatsuoIshii <span dir="ltr"><<a href="mailto:ishii@postgresql.org"
target="_blank">ishii@postgresql.org</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex"><div class="">> * Tatsuo Ishii (<a
href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>)wrote:<br /> >> I observe performance degradation
withPostgreSQL 9.3 vs 9.2 on Linux<br /> >> as well.  The hardware is HP DL980G7, 80 cores, 2TB mem, RHEL 6,<br
/>>> pgbench is used (read only query), scale factor is 1,000 (DB size<br /> >> 15GB).<br /> ><br />
>Can you isolate the sysv-vs-mmap patch and see what happens with just<br /> > that change..?<br /><br
/></div>UnfortunatelyI don't have an access to the machine at this moment.<br /><div class=""><br /> >> Included
isthe graph (from PostgreSQL Enterprise Consortium's 2014<br /> >> report page 13: <a
href="https://www.pgecons.org/downloads/43"target="_blank">https://www.pgecons.org/downloads/43</a>). I see up to
14%<br/> >> degration (at 128 concurrent users) comparing with 9.2.<br /> ><br /> > That URL returns
'Forbidden'...<br/><br /></div>Sorry for this. I sent a problem report to the person in charge.  In<br /> the mean
time,please go to:<br /><a href="https://www.pgecons.org/download/works_2013/"
target="_blank">https://www.pgecons.org/download/works_2013/</a>then click the link "2013<br /> 年度WG1活動報告" (sorry for
notEnglish). You should be able to<br /> download a report (PDF).<br /><br /> Also the report is written in Japanese. I
hopeyou can read at leat<br /> the graph in page 13 and the table in page 14.<br /></blockquote></div>Is pgecons
planningto do a translation of that at some point? It looks like good material, and the audience able to understand it
israther limited now :)<br /> -- <br />Michael<br /></div></div> 

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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD