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:33:46
Message-ID: hf0e33$bsd$ (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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:
>> 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 

In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2009-11-30 15:40:48
Subject: Re: query optimization
Previous:From: Bruce MomjianDate: 2009-11-30 12:08:22
Subject: Re: SSD + RAID

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