Ing . Marcos Luís Ortíz Valmaseda wrote:
> Regards to all the list.
> ZFS, the new filesystem developed by the Solaris Development team and
> ported to FreeBSD too, have many advantages that can do that all
> sysadmins are questioned
> about if it is a good filesystem to the PostgreSQL installation.
> Any of you haved tested this filesystem like PostgreSQL installation fs?
It will work but as to if it is a good file system for databases, the
debate still goes on.
Here are some links about ZFS and databases:
A separate issue (I think it is not explored enough in the above links)
is that ZFS writes data in a semi-continuous log, meaning there are no
in-place modifications of files (every such write is made on a different
place), which leads to heavy fragmentation. I don't think I have seen a
study of this particular effect. OTOH, it will only matter if the DB
usage pattern is sequential reads and lots of updates - and even here it
might be hidden by internal DB data fragmentation.
In response to
pgsql-performance by date
|Next:||From: Bruce Momjian||Date: 2009-11-30 12:08:22|
|Subject: Re: SSD + RAID|
|Previous:||From: Ing . Marcos Luís Ortíz Valmaseda||Date: 2009-11-30 06:27:09|
|Subject: Re: Any have tested ZFS like PostgreSQL installation filesystem?|