Re: Running PostgreSQL with ZFS ZIL - Mailing list pgsql-general

From Vick Khera
Subject Re: Running PostgreSQL with ZFS ZIL
Date
Msg-id CALd+dccS+qNMcbRGwfvO4Atc8M8uBDCw0BE+KzBCN27zmUqXTg@mail.gmail.com
Whole thread Raw
In response to Re: Running PostgreSQL with ZFS ZIL  (Joseph Kregloh <jkregloh@sproutloud.com>)
Responses Re: Running PostgreSQL with ZFS ZIL  (Joseph Kregloh <jkregloh@sproutloud.com>)
List pgsql-general

On Thu, Jul 2, 2015 at 10:56 AM, Joseph Kregloh <jkregloh@sproutloud.com> wrote:
With my dataset I have been able to take advantage of the L2ARC. Currently using about 80GB on ARC and 260GB on L2ARC. With the ARC currently having the greater Hit ratio.

Did you tell postgres that the effective_cache_size = Shared Buffers + ARC? I don't include in postgres the L2ARC size as it is not really in memory.  Also, I lie to postgres about the random_page_cost and seq_page_cost and set them both to 0.3 since there is so much cached.

Set full_page_writes = off since ZFS already takes care of that for you, too.


pgsql-general by date:

Previous
From: Alexander Shereshevsky
Date:
Subject: Re: record from plpgsql function performance
Next
From: Sylvain MARECHAL
Date:
Subject: Re: Getting the value of the old_tuple using the test_decoding extension and BDR