Ivan Voras escribió:
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.
OK, thanks for the answers, I ´ll study the efects now. This tests was
with the FreeBSD-8.0 version?
Regards.
--
-------------------------------------
"TIP 4: No hagas 'kill -9' a postmaster"
Ing. Marcos Luís Ortíz Valmaseda
PostgreSQL System DBA
Centro de Tecnologías de Almacenamiento y Anális de Datos (CENTALAD)
Universidad de las Ciencias Informáticas
Linux User # 418229
http://www.postgresql-es.org
http://www.postgresql.org
http://www.planetpostgresql.org
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
