Message-ID: <552D7168.3090909@agliodbs.com>
Date: Tue, 14 Apr 2015 12:58:32 -0700
From: Josh Berkus <josh@agliodbs.com>
Organization: PostgreSQL Experts Inc.
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.4.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Some performance testing?
References: <C855EB58-773C-48C4-B30F-64CF2481E69E@skogoglandskap.no>
	<CADCcZRmMuESyadD-buRPdcfDdGxVrUCNGUW5VdqNwh5koWziDQ@mail.gmail.com>
	<1247A199-6C8E-48FC-ADAA-BCA7DE5F90C3@skogoglandskap.no>
	<CADCcZRmrg820yvergYN6gpd+mnaqmehkZMDYqA6=hZmPTYd1bA@mail.gmail.com>
	<B83319DE-1521-48FF-90C3-135AD8465716@skogoglandskap.no>
 <CAOR=d=3O=_m+q5F3LYSWYyJG0kXA87GMSnV8r-unwj_oKumQhw@mail.gmail.com>
 <WM!0e4b4ccd00ea625c015af341b4312df98ac58127f1ef362a9e9fb6dd0a8f4fe373ec52679c2a706816abd402c495c57f!@asav-2.01.com>
In-Reply-To: 
 <WM!0e4b4ccd00ea625c015af341b4312df98ac58127f1ef362a9e9fb6dd0a8f4fe373ec52679c2a706816abd402c495c57f!@asav-2.01.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Scott,

> Can confirm that for pg purposes, 3.2 is basically broken in some not
> to great ways. We've had servers that were overloaded at load factors
> of 20 or 30 drop down to 5 or less with just a change from 3.2 to
> 3.11/3.13 on ubuntu 12.04

That's correct, and 3.5 shares the same problems.  The underlying issue
was that 3.X was tweaked to be MUCH more aggressive about
cache-clearing, to the point where it would be evicting data from the FS
cache which had just been read in and hadn't even been used yet.  For
some reason, this aggressive eviction got worse the more processes on
the system which were using the FS cache, so where you really see it is
when you have more processes with cache than you have cores.

It's pretty easy to demonstrate just using pgbench, with a database
larger than RAM, and 2X as many clients as cores.  You'll see that
kernels 3.2 and 3.5 will do 3X to 5X as much IO for the same workload as
3.10 and later will do.

Greame,

On 04/09/2015 04:01 AM, Graeme B. Bell wrote:> performance with 2.6:
(pgbench, size 100, 32 clients)
>
> 48 651 transactions per second (read only)
> 6 504 transactions per second (read-write)
>
>
> performance with 3.18 (pgbench, size 100, 32 clients)
>
> 129 303 transactions per second  (read only)
> 16 895 transactions (read-write)

Thanks for that data!  I'm glad to see that 3.18 has improved so much.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance