Linux vs. FreeBSD

On Tue, 7 Nov 2006 10:12:57 -0600
"Bart McFarling" <bartm@iilogistics.com> wrote:

We are installing a new Postgresql server, it will not run anything else
but postgresql. We are currently looking at moving from a RHEL 4.0
system to FreeBSD.

Does one OS offer better performace over the other when running
postgresql?

I had best performance on FreeBSD with his file system.

Look at this link.
http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance/node11.html

Bye Enrico

--
If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!!
scotty@linuxtime.it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi

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

On 11/10/06 02:24, Enrico wrote:

On Tue, 7 Nov 2006 10:12:57 -0600
"Bart McFarling" <bartm@iilogistics.com> wrote:

We are installing a new Postgresql server, it will not run anything else
but postgresql. We are currently looking at moving from a RHEL 4.0
system to FreeBSD.

Does one OS offer better performace over the other when running
postgresql?

I had best performance on FreeBSD with his file system.

Look at this link.
http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance/node11.html

Is this still accurate 3.75 years later?

- --
Ron Johnson, Jr.
Jefferson LA USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFVFbjS9HxQb37XmcRAiAsAKDkVN/WpHGyNIL8edGgjCk9XXu/BQCgxvwH
O0LOcYc2YJMhh7Tkxe6fouU=
=KAaz
-----END PGP SIGNATURE-----

Bart McFarling wrote:

We are installing a new Postgresql server, it will not run anything else
but postgresql. We are currently looking at moving from a RHEL 4.0
system to FreeBSD.

Does one OS offer better performace over the other when running
postgresql?

I'd guess the crucial thing will be:
1. Your experience in admin-ing each.
2. Hardware support for each.

Some theoretical advantage isn't any use if your RAID array has poor
drivers on Linux or you don't know how to tune Free-BSD.

--
Richard Huxton
Archonet Ltd

I had best performance on FreeBSD with his file system.

Look at this link.
http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance/node11.html

Is this still accurate 3.75 years later?

I don't know if is still accurate now, but
in my work I've seen that postgres with freeBSD
is more faster than postgres and Linux,
I used postgres with ext2 and ext3 filesystem.

Postgres was written under BSD systems and under BSD filesystem.

Regards,
Enrico

--
If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!!
scotty@linuxtime.it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi

Richard Huxton wrote:

Bart McFarling wrote:

We are installing a new Postgresql server, it will not run anything else
but postgresql. We are currently looking at moving from a RHEL 4.0
system to FreeBSD.
Does one OS offer better performace over the other when running
postgresql?

I'd guess the crucial thing will be:
1. Your experience in admin-ing each.
2. Hardware support for each.

Some theoretical advantage isn't any use if your RAID array has poor
drivers on Linux or you don't know how to tune Free-BSD.

Interesting. Instinctively, I'd have thought that, being more
main-stream, Linux has a better supply of drivers than Free-BSD. Have
you had any experience with Linux RAID drivers being poorer than Free BSD's?

P.

On Sun, 2006-11-12 at 12:01 +0100, Péter Kovács wrote:

Richard Huxton wrote:

Bart McFarling wrote:

We are installing a new Postgresql server, it will not run anything else
but postgresql. We are currently looking at moving from a RHEL 4.0
system to FreeBSD.
Does one OS offer better performace over the other when running
postgresql?

I'd guess the crucial thing will be:
1. Your experience in admin-ing each.
2. Hardware support for each.

Some theoretical advantage isn't any use if your RAID array has poor
drivers on Linux or you don't know how to tune Free-BSD.

Interesting. Instinctively, I'd have thought that, being more
main-stream, Linux has a better supply of drivers than Free-BSD. Have
you had any experience with Linux RAID drivers being poorer than Free BSD's?

You have to do your homework on FreeBSD as much as you do Linux. Most
RAID Drivers have caveats.

Joshua D. Drake

P.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate