Re: [PERFORM] ZFS vs. UFS

2012-07-31 Thread Craig James
On Tue, Jul 31, 2012 at 1:50 AM, Laszlo Nagy wrote: > > When Intel RAID controller is that? All of the ones on the motherboard >> are pretty much useless if that's what you have. Those are slower than >> software RAID and it's going to add driver issues you could otherwise >> avoid. Better to

Re: [PERFORM] ZFS vs. UFS

2012-07-31 Thread Laszlo Nagy
When Intel RAID controller is that? All of the ones on the motherboard are pretty much useless if that's what you have. Those are slower than software RAID and it's going to add driver issues you could otherwise avoid. Better to connect the drives to the non-RAID ports or configure the cont

Re: [PERFORM] ZFS vs. UFS

2012-07-26 Thread Greg Smith
On 07/24/2012 08:51 AM, Laszlo Nagy wrote: Under FreeBSD 9, what filesystem should I use for PostgreSQL? (Dell PowerEdge 2900, 24G mem, 10x2T SATA2 disk, Intel RAID controller.) When Intel RAID controller is that? All of the ones on the motherboard are pretty much useless if that's what you h

Re: [PERFORM] ZFS vs. UFS

2012-07-25 Thread Torsten Zuehlsdorff
On 24.07.2012 14:51, Laszlo Nagy wrote: * UFS is not journaled. There is journal support for UFS as far as i know. Please have a look at the gjournal manpage. > Yes, but gjournal works for disk devices. That isn't completly correct! gjournal works with all GEOM-devices, which could be n

Re: [PERFORM] ZFS vs. UFS

2012-07-24 Thread Craig James
On Tue, Jul 24, 2012 at 11:27 AM, Laszlo Nagy wrote: > > > 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 co

Re: [PERFORM] ZFS vs. UFS

2012-07-24 Thread Laszlo Nagy
On 24.07.2012 14:51, Laszlo Nagy wrote: * UFS is not journaled. There is journal support for UFS as far as i know. Please have a look at the gjournal manpage. Yes, but gjournal works for disk devices. I would have rely on the hw card for RAID. When the card goes wrong I won't be able to

Re: [PERFORM] ZFS vs. UFS

2012-07-24 Thread Laszlo Nagy
> 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 b

Re: [PERFORM] ZFS vs. UFS

2012-07-24 Thread Craig James
> > 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 c

Re: [PERFORM] ZFS vs. UFS

2012-07-24 Thread Torsten Zuehlsdorff
On 24.07.2012 14:51, Laszlo Nagy wrote: * UFS is not journaled. There is journal support for UFS as far as i know. Please have a look at the gjournal manpage. Greetings, Torsten -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscrip

Re: [PERFORM] ZFS vs. UFS

2012-07-24 Thread Ivan Voras
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 wron

Re: [PERFORM] ZFS vs. UFS

2012-07-24 Thread Georgi Naplatanov
Hi. As far as I know UFS is faster than ZFS on FreeBSD 9.0. Some users reported stability problem with ZFS on AMD64 and maybe UFS is better choice. Best regards Georgi On 07/24/2012 03:51 PM, Laszlo Nagy wrote: Hello, Under FreeBSD 9, what filesystem should I use for PostgreSQL? (Dell Pow