| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Best filesystem for a high load db |
| Date: | 2014-12-01 14:38:57 |
| Message-ID: | CALd+dcfuy_jp=-1WTf01UYoFrBPCTAmiQAZixWQAFd7QwBZ0BQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 26, 2014 at 10:53 AM, Joseph Kregloh <jkregloh(at)sproutloud(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vick Khera | 2014-12-01 14:40:23 | Re: Lock Management: Waiting on locks |
| Previous Message | Adrian Klaver | 2014-12-01 14:32:52 | Re: What is default password for user postgres |