From: | Craig James <cjames(at)emolecules(dot)com> |
---|---|
To: | Ivan Voras <ivoras(at)freebsd(dot)org> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: ZFS vs. UFS |
Date: | 2012-07-24 14:34:10 |
Message-ID: | CAFwQ8rcsbTwN6rDQJJbtkWDz-pVmA1bu7=1ewjU-eTLY=LjHOA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
>
> On 24/07/2012 14:51, Laszlo Nagy wrote:
> >
> > Hello,
> >
> > Under FreeBSD 9, what filesystem should I use for PostgreSQL? (Dell
> > PowerEdge 2900, 24G mem, 10x2T SATA2 disk, Intel RAID controller.)
> >
> > * ZFS is journaled, and it is more independent of the hardware. So if
> > the computer goes wrong, I can move the zfs array to a different
> server.
> > * UFS is not journaled. Also I have to rely on the RAID card to build
> > the RAID array. If there is a hw problem with it, then I won't be
> > able to recover the data easily.
> >
> > I wonder if UFS has better performance or not. Or can you suggest
> > another fs? Just of the PGDATA directory.
>
Relying on physically moving a disk isn't a good backup/recovery strategy.
Disks are the least reliable single component in a modern computer. You
should figure out the best file system for your application, and separately
figure out a recovery strategy, one that can survive the failure of *any*
component in your system, including the disk itself.
Craig
From | Date | Subject | |
---|---|---|---|
Next Message | Ioannis Anagnostopoulos | 2012-07-24 14:42:07 | Re: Heavy inserts load wile querying... |
Previous Message | Craig James | 2012-07-24 14:30:04 | Re: Heavy inserts load wile querying... |