Postgres Pro
Downloads
Home   >   mailing lists

Re: Scaling shared buffer eviction - Mailing list pgsql-hackers

From Thom Brown
Subject Re: Scaling shared buffer eviction
Date
Msg-id CAA-aLv6WX_b8WQwNu3VV94HfezfD8hfNn6be3UZ3=Qb5QX-umQ@mail.gmail.com
Whole thread Raw
In response to Re: Scaling shared buffer eviction  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Scaling shared buffer eviction
List pgsql-hackers
Tree view
On 5 September 2014 14:19, Amit Kapila <amit.kapila16@gmail.com> wrote:
On Fri, Sep 5, 2014 at 5:17 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> Apart from above, I think for this patch, cat version bump is required
> as I have modified system catalog.  However I have not done the
> same in patch as otherwise it will be bit difficult to take performance
> data.

One regression failed on linux due to spacing issue which is
fixed in attached patch.

Here's a set of test results against this patch:

8-core AMD FX-9590, 32GB RAM

Config:
checkpoint_segments = 256
checkpoint_timeout = 15min
shared_buffers = 8GB

pgbench scale factor = 3000
run duration time = 5min

HEAD
Client Count/No. Of Runs (tps) 8 16 32 64 128
Run-1 31568 41890 48638 49266 41845
Run-2 31613 41879 48597 49332 41736
Run-3 31674 41987 48647 49320 41745


Patch=scalable_buffer_eviction_v7.patch
Client Count/No. Of Runs (tps) 8 16 32 64 128
Run-1 31880 42943 49359 49901 43779
Run-2 32150 43078 48934 49828 43769
Run-3 32323 42894 49481 49600 43529

--
Thom

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: ALTER TABLESPACE MOVE command tag tweak
Next
From: Tomas Vondra
Date:
Subject: Re: bad estimation together with large work_mem generates terrible slow hash joins