Re: [WIP] Double-write with Fast Checksums

From: Jignesh Shah <jkshah(at)gmail(dot)com>
To: Dan Scales <scales(at)vmware(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>, David Fetter <david(at)fetter(dot)org>
Subject: Re: [WIP] Double-write with Fast Checksums
Date: 2012-01-18 20:50:35
Message-ID: CAGvK12Wqbt+02cRtK2omWDyV0D3RJ5QUiPoHUeazZxNcr+41hA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>              9.2 + DW patch
>              -----------------------------------
>              FPW off  FPW on  DW on/FPW off
>              CK on    CK on   CK on
> one disk:     11078   10394    3296  [1G shared_buffers, 8G RAM]
> sep log disk: 13605   12015    3412
>
> one disk:      7731    6613    2670  [1G shared_buffers, 2G RAM]
> sep log disk:  6752    6129    2722
>

On my single Hard disk test with write cache turned off I see
different results than what Dan sees..
DBT2 50-warehouse, 1hr steady state with shared_buffers 1G,
checkpoint_segments=128 as common settings on 8GB RAM)
(checkpoints were on for all cases) with 8 Core .

FPW off: 3942.25 NOTPM
FPW on: 3613.37 NOTPM
DW on : 3479.15 NOTPM

I retried it with 2 core also and get similar results. So high
evictions does have slighly higher penalty than FPW.

My run somehow did not collect the background writer stats so dont
have that comparison for these runs but have fixed it for the next
runs.

Regards,
Jignesh

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2012-01-18 20:51:49 Re: Command Triggers
Previous Message Simon Riggs 2012-01-18 20:37:31 Re: age(xid) on hot standby