From: Trygve Laugstøl <trygvis@inamo.no>
To: pgsql-performance@postgresql.org
Subject: Re: Best OS for Postgres 8.2
Date: Tue, 08 May 2007 10:49:49 +0200
Message-ID: <464039AD.40407@inamo.no> (raw)
In-Reply-To: <Pine.LNX.4.64.0705080140060.24680@asgard.lang.hm>
References: <1178574927.533849.90730@e51g2000hsg.googlegroups.com>
<B699315F-9D8D-40E7-9C42-DD0C9E7DEA4F@blighty.com>
<463FFF76.5070108@gmail.com>
<Pine.LNX.4.64.0705080043120.24680@asgard.lang.hm>
<b41c75520705080122q58b36e36x21f6147ae5adaa81@mail.gmail.com>
<Pine.LNX.4.64.0705080140060.24680@asgard.lang.hm>
david@lang.hm wrote:
> On Tue, 8 May 2007, Claus Guttesen wrote:
>
>>> > In #postgresql on freenode, somebody ever mentioned that ZFS from
>>> > Solaris
>>> > helps a lot to the performance of pgsql, so dose anyone have
>>> information
>>> > about that?
>>>
>>> the filesystem you use will affect the performance of postgres
>>> significantly. I've heard a lot of claims for ZFS, unfortunantly
>>> many of
>>> them from people who have prooven that they didn't know what they were
>>> talking about by the end of their first or second e-mails.
>>>
>>> much of the hype for ZFS is it's volume management capabilities and
>>> admin
>>> tools. Linux has most (if not all) of the volume management
>>> capabilities,
>>> it just seperates them from the filesystems so that any filesystem
>>> can use
>>> them, and as a result you use one tool to setup your RAID, one to setup
>>> snapshots, and a third to format your filesystems where ZFS does
>>> this in
>>> one userspace tool.
>>
>> Even though those posters may have proven them selves wrong, zfs is
>> still a very handy fs and it should not be judged relative to these
>> statements.
>
> I don't disagree with you, I'm just noteing that too many of the 'ZFS is
> great' posts need to be discounted as a result (the same thing goes for
> the 'reiserfs4 is great' posts)
>
>>> once you seperate the volume management piece out, the actual
>>> performance
>>> question is a lot harder to answer. there are a lot of people who
>>> say that
>>> it's far faster then the alternate filesystems on Solaris, but I
>>> haven't
>>> seen any good comparisons between it and Linux filesystems.
>>
>> One could install pg on solaris 10 and format the data-area as ufs and
>> then as zfs and compare import- and query-times and other benchmarking
>> but comparing ufs/zfs to Linux-filesystems would also be a comparison
>> of those two os'es.
>
> however, such a comparison is very legitimate, it doesn't really matter
> which filesystem is better if the OS that it's tied to limits it so much
> that the other one wins out with an inferior filesystem
>
> currently ZFS is only available on Solaris, parts of it have been
> released under GPLv2, but it doesn't look like enough of it to be ported
> to Linux (enough was released for grub to be able to access it
> read-only, but not the full filesystem). there are also patent concerns
> that are preventing any porting to Linux.
This is not entirely correct. ZFS is only under the CDDL license and it
has been ported to FreeBSD.
http://mail.opensolaris.org/pipermail/zfs-discuss/2007-April/026922.html
--
Trygve
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: trygvis@inamo.no
Subject: Re: Best OS for Postgres 8.2
In-Reply-To: <464039AD.40407@inamo.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox