Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4
Дата
Msg-id CALd+dcdfCWHBHPiC=4JrHMgzwGpx-PhwK1GzHh5gyivJvru+=A@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4  (Toby Corkindale <toby.corkindale@strategicdata.com.au>)
Ответы Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4
Список 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 по дате отправления:

Предыдущее
От: Vick Khera
Дата:
Сообщение: Re: Noob help for charting on web site, need assistance
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: different unnest function