Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD
Дата
Msg-id 20140422004918.GD2556@tamriel.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  (Tatsuo Ishii <ishii@postgresql.org>)
Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD  (Andrew Dunstan <andrew@dunslane.net>)
Список 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..?

> 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'...
Thanks,
    Stephen

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Clock sweep not caching enough B-Tree leaf pages?