Re: Any have tested ZFS like PostgreSQL installation filesystem? - Mailing list pgsql-performance

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