Re: Scaling shared buffer eviction

On 5 September 2014 14:19, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:

> On Fri, Sep 5, 2014 at 5:17 PM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)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