Skip site navigation (1) Skip section navigation (2)

Re: Any have tested ZFS like PostgreSQL installation filesystem?

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 (view raw or flat)
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.



In response to

Responses

pgsql-performance by date

Next:From: Bruce MomjianDate: 2009-11-30 12:08:22
Subject: Re: SSD + RAID
Previous:From: Ing . Marcos Luís Ortíz ValmasedaDate: 2009-11-30 06:27:09
Subject: Re: Any have tested ZFS like PostgreSQL installation filesystem?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group