| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Joseph Kregloh <jkregloh(at)sproutloud(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Running PostgreSQL with ZFS ZIL |
| Date: | 2015-07-02 15:50:00 |
| Message-ID: | CALd+dccS+qNMcbRGwfvO4Atc8M8uBDCw0BE+KzBCN27zmUqXTg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jul 2, 2015 at 10:56 AM, Joseph Kregloh <jkregloh(at)sproutloud(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sylvain MARECHAL | 2015-07-02 16:14:00 | Re: Getting the value of the old_tuple using the test_decoding extension and BDR |
| Previous Message | Alexander Shereshevsky | 2015-07-02 15:09:38 | Re: record from plpgsql function performance |