Thread: Linux vs. FreeBSD
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?
Thanks,
Bart
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