Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: girgen(at)FreeBSD(dot)org, pgsql-hackers(at)postgresql(dot)org, robertmhaas(at)gmail(dot)com, ftigeot(at)wolfpond(dot)org
Subject: Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD
Date: 2014-04-22 00:49:18
Message-ID: 20140422004918.GD2556@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Tatsuo Ishii (ishii(at)postgresql(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-04-22 00:50:20 Re: Clock sweep not caching enough B-Tree leaf pages?
Previous Message Joshua D. Drake 2014-04-22 00:44:21 Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD