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:
http://blogs.sun.com/paulvandenbogaard/entry/postgresql_on_ufs_versus_zfs
http://blogs.sun.com/paulvandenbogaard/entry/running_postgresql_on_zfs_file
http://blogs.sun.com/realneel/entry/mysql_innodb_zfs_best_practices
http://dev.mysql.com/tech-resources/articles/mysql-zfs.html
http://blogs.smugmug.com/don/2008/10/13/zfs-mysqlinnodb-compression-update/
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.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
