Thread: Any have tested ZFS like PostgreSQL installation filesystem?
Any have tested ZFS like PostgreSQL installation filesystem?
From
"Ing . Marcos Luís Ortíz Valmaseda"
Date:
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? 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
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.
Re: Any have tested ZFS like PostgreSQL installation filesystem?
From
"Ing . Marcos Luís Ortíz Valmaseda"
Date:
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
Ing . Marcos Luís Ortíz Valmaseda wrote: > 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? No, AFAIK all of them were on some (and different) versions of (Open)Solaris.