Best Linux Distribution
I'm starting to develop a production enviroment with Postgres and Tomcat, And I have to choose between some free linux distribution like:
whitebox
RHEL
Fedora
Suse
Which is the better distribution in terms of postgres? if this has an answer
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Sat, 8 Jan 2005, Esteban Kemp wrote:
I'm starting to develop a production enviroment with Postgres and Tomcat, And I have to choose between some free linux distribution like:
whitebox
RHEL
RHEL is not free (of charge).
Fedora
Suse
SLES is again not free of charge.
Which is the better distribution in terms of postgres? if this has an answer
All have PostgreSQL included within the distribution.
IMHO, Red Hat Enterprise Linux (Or WBEL, its clone...) is the best among
these... Red Hat also has an application server which has Tomcat
installed, AFAIR.
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD4DBQFB7m0ltl86P3SPfQ4RAri9AKCHMJgrgb2V9+U/4KlwWPk3zHjrOQCY02WE
hiHnUsWBk/6xkOTcV0DD/Q==
=gbuj
-----END PGP SIGNATURE-----
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 :)
Hope this helps,
On Sat, Jan 08, 2005 at 11:14:00AM -0300, Esteban Kemp wrote:
I'm starting to develop a production enviroment with Postgres and
Tomcat, And I have to choose between some free linux distribution
like:whitebox
RHEL
Fedora
SuseWhich is the better distribution in terms of postgres? if this has an answer
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
Devrim GUNDUZ wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1Hi,
On Sat, 8 Jan 2005, Esteban Kemp wrote:
I'm starting to develop a production enviroment with Postgres and
Tomcat, And I have to choose between some free linux distribution like:whitebox
RHELRHEL is not free (of charge).
Fedora
SuseSLES is again not free of charge.
You can download a variation of SuSE 9.2 pro now. I say a variation
because it's a dvd iso which is around 4g, whereas the dvd that comes
with the boxed 9.2 pro is a dual-layer and +7g.
I don't know what the differences are between the two.
--
Until later, Geoffrey
You should look www.linuxiso.org.
There you may find the ISO of a great variety of distros.
C ya,
Bruno Almeida do Lago
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Geoffrey
Sent: Wednesday, January 19, 2005 1:01 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best Linux Distribution
Devrim GUNDUZ wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1Hi,
On Sat, 8 Jan 2005, Esteban Kemp wrote:
I'm starting to develop a production enviroment with Postgres and
Tomcat, And I have to choose between some free linux distribution like:whitebox
RHELRHEL is not free (of charge).
Fedora
SuseSLES is again not free of charge.
You can download a variation of SuSE 9.2 pro now. I say a variation
because it's a dvd iso which is around 4g, whereas the dvd that comes
with the boxed 9.2 pro is a dual-layer and +7g.
I don't know what the differences are between the two.
--
Until later, Geoffrey
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
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.
Sincerely,
Joshua D. Drake
Hope this helps,
On Sat, Jan 08, 2005 at 11:14:00AM -0300, Esteban Kemp wrote:
I'm starting to develop a production enviroment with Postgres and
Tomcat, And I have to choose between some free linux distribution
like:whitebox
RHEL
Fedora
SuseWhich is the better distribution in terms of postgres? if this has an answer
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
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.Sincerely,
Joshua D. Drake
Out of curiousity, which fs would you recommend for a ~terabyte oltp db?
--
_______________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________
On Wed, 19 Jan 2005 09:03:31 -0800, Joshua D. Drake
<jd@www.commandprompt.com> 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.
On whitebox & RHEL ext3 is really the only choice. However, FC3
provides all the other major filesystems as choices (XFS, reiser).
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org
When I had customers faced with this decision, we made the
recommendation based on which distro employs major contributors
of the software project in question.
For Postgresql's case, RedHat's employment of Tom made
our recommendation to use Red Hat.
Some of our clients are running .NET front ends, so we're
recommending Novel/SuSE for those.
It's a mix of superstition that the vendors platform is
may see earlier testing, along with rewarding the vendor
for supporting the project.
Ron
PS: All you open source vendors who employ important
developers -- Thank You - this contribution does not go unnoticed.
Martijn van Oosterhout wrote:
Show quoted text
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 :)Hope this helps,
On Sat, Jan 08, 2005 at 11:14:00AM -0300, Esteban Kemp wrote:
I'm starting to develop a production enviroment with Postgres and
Tomcat, And I have to choose between some free linux distribution
like:whitebox
RHEL
Fedora
SuseWhich is the better distribution in terms of postgres? if this has an answer
On Wed, 19 Jan 2005 09:19:33 -0800, Bricklen Anderson
<BAnderson@presinet.com> wrote:
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.Sincerely,
Joshua D. Drake
Out of curiousity, which fs would you recommend for a ~terabyte oltp db?
XFS without a doubt. XFS has excellent large file (and filesystem) support.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org
Sincerely,
Joshua D. Drake
Out of curiousity, which fs would you recommend for a ~terabyte oltp db?
XFS without a doubt. XFS has excellent large file (and filesystem) support.
I second the XFS statement.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
Lonni J Friedman wrote:
On whitebox & RHEL ext3 is really the only choice. However, FC3
provides all the other major filesystems as choices (XFS, reiser).
I just tried to install FC3 AMD64, and the only choice it would give me
for an installation was ext3. Since I prefer Reiser, I gave up and
installed Gentoo.
--
Guy Rouillier
Import Notes
Resolved by subject fallback
Guy Rouillier wrote:
Lonni J Friedman wrote:
On whitebox & RHEL ext3 is really the only choice. However, FC3
provides all the other major filesystems as choices (XFS, reiser).I just tried to install FC3 AMD64, and the only choice it would give me
for an installation was ext3. Since I prefer Reiser, I gave up and
I am running FC3 with XFS :)
installed Gentoo.'
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Wed, 19 Jan 2005, Guy Rouillier wrote:
On whitebox & RHEL ext3 is really the only choice. However, FC3
provides all the other major filesystems as choices (XFS, reiser).I just tried to install FC3 AMD64, and the only choice it would give me
for an installation was ext3. Since I prefer Reiser, I gave up and
installed Gentoo.
AFAIR, if you run anaconda with
linux reiserfs
then reiserfs will appear among available file lists.
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFB7rdutl86P3SPfQ4RAkV1AJ46FLnDuLRDYvNQj/OGC8ck1JpobQCbBih+
+/gKEgPZFRBfMAJPP5uWbVM=
=NwkB
-----END PGP SIGNATURE-----
On Wed, 19 Jan 2005 21:39:23 +0200 (EET), Devrim GUNDUZ
<devrim@gunduz.org> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1Hi,
On Wed, 19 Jan 2005, Guy Rouillier wrote:
On whitebox & RHEL ext3 is really the only choice. However, FC3
provides all the other major filesystems as choices (XFS, reiser).I just tried to install FC3 AMD64, and the only choice it would give me
for an installation was ext3. Since I prefer Reiser, I gave up and
installed Gentoo.AFAIR, if you run anaconda with
linux reiserfs
then reiserfs will appear among available file lists.
That is correct. It works similarly for xfs.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org
I still opt for Slackware simplicity and stability. Nothing better than a
well configured Slackware box with XFS file system and PostgreSQL! =)
C Ya,
Bruno
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Ron Mayer
Sent: Wednesday, January 19, 2005 3:32 PM
To: Martijn van Oosterhout; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best Linux Distribution
When I had customers faced with this decision, we made the
recommendation based on which distro employs major contributors
of the software project in question.
For Postgresql's case, RedHat's employment of Tom made
our recommendation to use Red Hat.
Some of our clients are running .NET front ends, so we're
recommending Novel/SuSE for those.
It's a mix of superstition that the vendors platform is
may see earlier testing, along with rewarding the vendor
for supporting the project.
Ron
PS: All you open source vendors who employ important
developers -- Thank You - this contribution does not go unnoticed.
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 :)Hope this helps,
On Sat, Jan 08, 2005 at 11:14:00AM -0300, Esteban Kemp wrote:
I'm starting to develop a production enviroment with Postgres and
Tomcat, And I have to choose between some free linux distribution
like:whitebox
RHEL
Fedora
SuseWhich is the better distribution in terms of postgres? if this has an
answer
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
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
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:
Show quoted text
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
Alle 10:09, giovedì 20 gennaio 2005, Bruno Almeida do Lago ha scritto:
I still opt for Slackware simplicity and stability. Nothing better than a
well configured Slackware box with XFS file system and PostgreSQL! =)C Ya,
Bruno
For a generic use of postgresql, binary packages in any linux distribution
are good and reliable. In some cases, i.e. in a production context where you
have to optimize your postgresql, the ability of configuring and compiling
postgresql from sources is a must. This should make you use a more flexible
distribution like slackware and gentoo with which you can prepare your linux
box from scratch by compiling everything according to your needs (it isn't
enough to have a binary linux distribituion installed and only postgresql
compiled from sources).
Ciao
Vittorio
-----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?
- -----------------------------------------------------------
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
