Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4 - Mailing list pgsql-general

From Vick Khera
Subject Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4
Date
Msg-id CALd+dcdfCWHBHPiC=4JrHMgzwGpx-PhwK1GzHh5gyivJvru+=A@mail.gmail.com
Whole thread Raw
In response to PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4  (Toby Corkindale <toby.corkindale@strategicdata.com.au>)
Responses Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4  (Toby Corkindale <toby.corkindale@strategicdata.com.au>)
List pgsql-general
On Tue, Sep 13, 2011 at 9:15 PM, Toby Corkindale
<toby.corkindale@strategicdata.com.au> wrote:
> However we have a new contender - ZFS performed *extremely* well on the
> latest Ubuntu setup - achieving triple the performance of regular ext4!

Did you do any tuning to ZFS?  There are many tweaks to it, like
putting a cache disk in front of it, or moving the logs to SSD and
such.  I haven't run any produciton DBs on ZFS yet, but it sure is
tempting.  The speed penalty for the features it gives you (snapshots,
robust against power fails, etc.) is worth the tradeoff.

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Noob help for charting on web site, need assistance
Next
From: "David Johnston"
Date:
Subject: Re: different unnest function