Re: Best filesystem for a high load db - Mailing list pgsql-general

From Vick Khera
Subject Re: Best filesystem for a high load db
Date
Msg-id CALd+dcfuy_jp=-1WTf01UYoFrBPCTAmiQAZixWQAFd7QwBZ0BQ@mail.gmail.com
Whole thread Raw
In response to Re: Best filesystem for a high load db  (Joseph Kregloh <jkregloh@sproutloud.com>)
List pgsql-general

On Wed, Nov 26, 2014 at 10:53 AM, Joseph Kregloh <jkregloh@sproutloud.com> wrote:
One thing I am pushing to do is using SSDs for the ZIL and L2ARC. This would allow for a pretty nice boost in speed.

I use ZFS on freebsd as my large production server configuration as well. I have SSDs for the L2ARC and that works *really* well. I do not use a ZIL at all. Using the ZFS compression is a big win, along with all the other management advantages you already outlined.

There is a minor speed penalty, but the other advantages far outweigh those. That and throwing 256GB of RAM at the problem makes it more or less go away.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: What is default password for user postgres
Next
From: Vick Khera
Date:
Subject: Re: Lock Management: Waiting on locks