Re: [GENERAL] Linux vs FreeBSD

2014-04-11 Thread Achilleas Mantzios
Basically it goes beyond what ppl would describe as OS holly wars. If one chooses to go by FreeBSD, then he better be prepared to handle the burden, both the part that is imposed by the OS administration itself, as well as the part that is a side effect of the different base system. Example of

Re: [GENERAL] Linux vs FreeBSD

2014-04-11 Thread Alban Hertroys
On 11 Apr 2014, at 8:04, Achilleas Mantzios ach...@matrix.gatewaynet.com wrote: Basically it goes beyond what ppl would describe as OS holly wars. If one chooses to go by FreeBSD, then he better be prepared to handle the burden, both the part that is imposed by the OS administration itself,

Re: [GENERAL] Linux vs FreeBSD

2014-04-11 Thread Achilleas Mantzios
On 11/04/2014 13:05, Alban Hertroys wrote: On 11 Apr 2014, at 8:04, Achilleas Mantzios ach...@matrix.gatewaynet.com wrote: Basically it goes beyond what ppl would describe as OS holly wars. If one chooses to go by FreeBSD, then he better be prepared to handle the burden, both the part that

Re: [GENERAL] Linux vs FreeBSD

2014-04-11 Thread Alban Hertroys
On 11 Apr 2014, at 12:39, Achilleas Mantzios ach...@matrix.gatewaynet.com wrote: I moved this bit of the conversation up as it’s relevant to the OP: On 11/04/2014 13:05, Alban Hertroys wrote: On 11 Apr 2014, at 8:04, Achilleas Mantzios ach...@matrix.gatewaynet.com wrote: I don't mean to

Re: [GENERAL] Linux vs FreeBSD

2014-04-11 Thread Steve Litt
On Fri, 11 Apr 2014 14:05:43 +0200 Alban Hertroys haram...@gmail.com wrote: My advice to the OP: Install FreeBSD on a system to play around with, get a feel for how it works and whether you like it or not. See how it performs with Postgres on different file-systems; UFS2 or ZFS - UFS is the

Re: [GENERAL] Linux vs FreeBSD

2014-04-11 Thread D'Arcy J.M. Cain
On Fri, 11 Apr 2014 09:16:04 -0400 Steve Litt sl...@troubleshooters.com wrote: Curious: Why not consider OpenBSD also? Or NetBSD. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246

Re: [GENERAL] Linux vs FreeBSD

2014-04-11 Thread Achilleas Mantzios
On 11/04/2014 15:05, Alban Hertroys wrote: Although it is getting a bit specific, would you care to elaborate why you would advice strongly against using ports or packages for Postgres on FreeBSD? Because that’s a rather strong statement you’re making and so far the only argument I’ve seen is

Re: [GENERAL] Linux vs FreeBSD

2014-04-11 Thread D'Arcy J.M. Cain
On Fri, 11 Apr 2014 17:15:28 +0300 Achilleas Mantzios ach...@matrix.gatewaynet.com wrote: pl/java has nothing to do with this. The argument against using packages/ports for postgresql upgrades, is that upgrades in general involve : - reading HISTORY thoroughly and understanding every bit of

Re: [GENERAL] Linux vs FreeBSD

2014-04-10 Thread Stuart Bishop
On 4 April 2014 11:03, François Beausoleil franc...@teksol.info wrote: Hi all! Does PG perform that much better on FreeBSD? I have some performance issues on a Ubuntu 12.04 which I'd like to resolve. iowait varies a lot, between 5 and 50%. Does FreeBSD better schedule I/O, which could

Re: [GENERAL] Linux vs FreeBSD

2014-04-10 Thread Christofer C. Bell
On Wed, Apr 9, 2014 at 3:36 PM, François Beausoleil franc...@teksol.info wrote: Le 2014-04-09 à 16:20, Bruce Momjian a écrit : On Wed, Apr 9, 2014 at 10:02:07AM -0500, Christofer C. Bell wrote: This highlights a more fundamental problem of the difference between a workstation-based on OS

Re: [GENERAL] Linux vs FreeBSD

2014-04-10 Thread Jan Wieck
On 04/10/14 17:25, Christofer C. Bell wrote: I'm not wanting to get after anyone here, but I want it on the record that I am not the source of the above quote discouraging the use of Ubuntu in a server role. That would be Bruce Momjian. While Bruce is entitled to his opinion, it's not one I

Re: [GENERAL] Linux vs FreeBSD

2014-04-09 Thread Christofer C. Bell
On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil franc...@teksol.info wrote: Hi all! Does PG perform that much better on FreeBSD? I have some performance issues on a Ubuntu 12.04 which I'd like to resolve. iowait varies a lot, between 5 and 50%. Does FreeBSD better schedule I/O, which

Re: [GENERAL] Linux vs FreeBSD

2014-04-09 Thread Bruce Momjian
On Wed, Apr 9, 2014 at 10:02:07AM -0500, Christofer C. Bell wrote: On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil franc...@teksol.info wrote: Hi all! Does PG perform that much better on FreeBSD? I have some performance issues on a Ubuntu 12.04 which I'd like to resolve. iowait

Re: [GENERAL] Linux vs FreeBSD

2014-04-09 Thread Scott Marlowe
On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell christofer.c.b...@gmail.com wrote: On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil franc...@teksol.info wrote: Hi all! Does PG perform that much better on FreeBSD? I have some performance issues on a Ubuntu 12.04 which I'd like to

Re: [GENERAL] Linux vs FreeBSD

2014-04-09 Thread François Beausoleil
Le 2014-04-09 à 16:20, Bruce Momjian a écrit : On Wed, Apr 9, 2014 at 10:02:07AM -0500, Christofer C. Bell wrote: This highlights a more fundamental problem of the difference between a workstation-based on OS like Ubuntu and a server-based one like Debian or FreeBSD. I know Ubuntu has a

Re: [GENERAL] Linux vs FreeBSD

2014-04-09 Thread Steve Atkins
On Apr 9, 2014, at 1:33 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell christofer.c.b...@gmail.com wrote: On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil franc...@teksol.info wrote: Hi all! Does PG perform that much better on

Re: [GENERAL] Linux vs FreeBSD

2014-04-09 Thread Scott Marlowe
On Wed, Apr 9, 2014 at 2:56 PM, Steve Atkins st...@blighty.com wrote: On Apr 9, 2014, at 1:33 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell christofer.c.b...@gmail.com wrote: On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil

Re: [GENERAL] Linux vs FreeBSD

2014-04-09 Thread Bosco Rama
On 04/09/14 14:46, Scott Marlowe wrote: I'm not deploying any new distro version that soon. :) I know folks just putting 12.04 into prod to replace etch and lenny. :) You can easily get the 3.11.0 kernel on 12.04.4 LTS by installing the linux-generic-lts-saucy package. IIRC, the fix for the

Re: [GENERAL] Linux vs FreeBSD

2014-04-09 Thread Brent Wood
-general@postgresql.org Subject: Re: [GENERAL] Linux vs FreeBSD Le 2014-04-09 ? 16:20, Bruce Momjian a ?crit : On Wed, Apr 9, 2014 at 10:02:07AM -0500, Christofer C. Bell wrote: This highlights a more fundamental problem of the difference between a workstation-based on OS like Ubuntu and a server

Re: [GENERAL] Linux vs FreeBSD

2014-04-09 Thread Alan Hodgson
On Wednesday, April 09, 2014 09:02:02 PM Brent Wood wrote: Given the likely respective numbers of each OS actually out there, I'd suggests BSD is very over-represented in the high uptime list which is suggestive. Suggestive of ... sysadmins who don't do kernel updates? -- Sent via

Re: [GENERAL] Linux vs FreeBSD

2014-04-08 Thread Vick Khera
On Fri, Apr 4, 2014 at 12:03 AM, François Beausoleil franc...@teksol.info wrote: Our workload is lots of data import, followed by many queries to summarize (daily and weekly reports). Our main table is a wide table that represents Twitter and Facebook interactions. Most of our reports work on

Re: [GENERAL] Linux vs FreeBSD

2014-04-04 Thread Achilleas Mantzios
FreeBSD is OK if you are experienced. As a system it requires much more maturity by the admin than lets say Ubuntu which is targeted at a larger user base. I'd say, explore your other Linux options first, since you already have experience with Linux. FreeBSD requires a much bigger learning

Re: [GENERAL] Linux vs FreeBSD

2014-04-04 Thread Ray Stell
On Apr 4, 2014, at 12:03 AM, François Beausoleil franc...@teksol.info wrote: I have some performance issues on a Ubuntu 12.04 which I'd like to resolve. iowait varies a lot, between 5 and 50%. Is the SAN dedicated to this app? I wonder if the i/o, if not related to your app, is being

Re: [GENERAL] Linux vs FreeBSD

2014-04-04 Thread François Beausoleil
Le 2014-04-04 à 08:11, Ray Stell a écrit : On Apr 4, 2014, at 12:03 AM, François Beausoleil franc...@teksol.info wrote: I have some performance issues on a Ubuntu 12.04 which I'd like to resolve. iowait varies a lot, between 5 and 50%. Is the SAN dedicated to this app? I wonder if

Re: [GENERAL] Linux vs FreeBSD

2014-04-04 Thread Achilleas Mantzios
As a side note, when we migrated the exact same pgsql 8.3 system from linux kernel 2.6 to 3.6, we experienced an almost dramatic slowdown by 6 times. Linux Kernel's were known to have issues around those dates, i recall. We had to set synchronous_commit to off, this gave a huge boost , but this

[GENERAL] Linux vs FreeBSD

2014-04-03 Thread François Beausoleil
Hi all! Does PG perform that much better on FreeBSD? I have some performance issues on a Ubuntu 12.04 which I'd like to resolve. iowait varies a lot, between 5 and 50%. Does FreeBSD better schedule I/O, which could alleviate some of the issues, or not at all? I have no experience administering

Re: [GENERAL] Linux vs FreeBSD

2014-04-03 Thread John R Pierce
On 4/3/2014 9:03 PM, François Beausoleil wrote: The host is a dedicated hardware machine at online.fr: 128 GB RAM, 2 x 3TB disk in RAID 1 configuration. just a passing comment... 3TB disks are 7200rpm and suitable for nearline bulk storage (or desktop use), not high performance database

Re: [GENERAL] Linux vs FreeBSD

2014-04-03 Thread Amitabh Kant
On Fri, Apr 4, 2014 at 9:33 AM, François Beausoleil franc...@teksol.infowrote: Hi all! Does PG perform that much better on FreeBSD? I have some performance issues on a Ubuntu 12.04 which I'd like to resolve. iowait varies a lot, between 5 and 50%. Does FreeBSD better schedule I/O, which

Re: [GENERAL] Linux vs. FreeBSD

2006-11-12 Thread Péter Kovács
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

Re: [GENERAL] Linux vs. FreeBSD

2006-11-12 Thread Joshua D. Drake
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

Re: [GENERAL] Linux vs. FreeBSD

2006-11-10 Thread Enrico
On Tue, 7 Nov 2006 10:12:57 -0600 Bart McFarling [EMAIL PROTECTED] 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

Re: [GENERAL] Linux vs. FreeBSD

2006-11-10 Thread Ron Johnson
-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 [EMAIL PROTECTED] 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

Re: [GENERAL] Linux vs. FreeBSD

2006-11-10 Thread Richard Huxton
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

Re: [GENERAL] Linux vs. FreeBSD

2006-11-10 Thread Enrico
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

[GENERAL] Linux vs. FreeBSD

2006-11-09 Thread Bart McFarling
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