From: | Ivan Voras <ivoras(at)freebsd(dot)org> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Any have tested ZFS like PostgreSQL installation filesystem? |
Date: | 2009-11-30 12:00:47 |
Message-ID: | hf0c58$5u9$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2009-11-30 12:08:22 | Re: SSD + RAID |
Previous Message | Ing . Marcos Luís Ortíz Valmaseda | 2009-11-30 06:27:09 | Re: Any have tested ZFS like PostgreSQL installation filesystem? |