On Thu, Jul 2, 2015 at 10:56 AM, Joseph Kregloh <jkreg...@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.
