Re: Best Linux Distribution - Mailing list pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I think you forget the origins of the XFS filesystem.  XFS was
originally created for SGI's IRIX operating system, and specifically
designed for handling large files and filesystems at high speeds.  It
is very fast, and quite well tested: it was in heavy use on IRIX
systems before ever having been made available for Linux.


Check it out here:

http://oss.sgi.com/projects/xfs/


On Jan 20, 2005, at 7:23 AM, Abdul-Wahid Paterson wrote:

> I think the filesystem you choose depends what you are looking for.
> Ext3 is by far the most tested and most stable out the file systems
> available. It is basically just ext2 with journalling stuck on top
> (and a few other niceities). XFS may well be faster but is perhaps not
> so well tested or as stable. My choise for stability would be ext3 and
> for speed would be xfs.
>
> As for the OS, it probably doesn't make much difference. My personal
> choice though is gentoo. My reasons are.
>
> 1. The postgres server is compiled with optimised gcc flags.
> 2. Gentoo have many different versions of postgres available and is
> easy to upgrade /change between versions. Looking at the versions
> available now they have from
> 7.3.6 to 8.0. (8.0 is still marked as testing)
>
> Regards,
>
> Abdul-Wahid
>
>
>
> On Thu, 20 Jan 2005 11:34:31 +0100 (CET), Marco Colombo
> <pgsql@esiway.net> wrote:
>> On Wed, 19 Jan 2005, Joshua D. Drake wrote:
>>
>>> Martijn van Oosterhout wrote:
>>>
>>>> No difference whatsoever from PostgreSQL's point of view. Use
>>>> whichever
>>>> distribution is easiest for you to administer. After all, there's no
>>>> point installing Postgres on a machine you don't know how to
>>>> maintain
>>>> or tune :)
>>>>
>>> Actually there is a difference from PostgreSQL's point of view :)
>>> Namely in filesystems. The default filesystem on whitebox, RHEL and
>>> Fedora is EXT3 which really isn't that great.
>>                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>>
>> Is there any evidence of the above claim? I've seen a link to a l-k
>> bug report about ext3, but apparently it was totally unconfirmed
>> (and a single bug does not mean a FS is not good - I remember XFS
>> being hammered heavily before being accepted into Linux).
>>
>> I'm using ext3 cause all other FSes are simple add-ons in linux.
>> All of them struggled a lot before being able to meet linux high
>> quality standards and being accepted into mainstream. Ext3 was there
>> from the start. Of course that doesn't mean it fits PostgreSQL needs
>> better than other FSes.
>>
>> .TM.
>> --
>>        ____/  ____/   /
>>       /      /       /                  Marco Colombo
>>      ___/  ___  /   /                 Technical Manager
>>     /          /   /                     ESI s.r.l.
>>   _____/ _____/  _/                    Colombo@ESI.it
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 9: the planner will ignore your desire to choose an index scan if
>> your
>>       joining column's datatypes do not match
>>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>
- -----------------------------------------------------------
Frank D. Engel, Jr.  <fde101@fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFB77hE7aqtWrR9cZoRAqWDAJ90Ia0RaqdDydLBZ1qY87QlohuU4ACgkltP
FoATmnsg3CxK5TLiVtdcSAk=
=ck94
-----END PGP SIGNATURE-----



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com