Re: Scaling shared buffer eviction
От | Thom Brown |
---|---|
Тема | Re: Scaling shared buffer eviction |
Дата | |
Msg-id | CAA-aLv6WX_b8WQwNu3VV94HfezfD8hfNn6be3UZ3=Qb5QX-umQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Scaling shared buffer eviction (Amit Kapila <amit.kapila16@gmail.com>) |
Ответы |
Re: Scaling shared buffer eviction
|
Список | pgsql-hackers |
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 isfixed 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 по дате отправления: