On Fri, 11 Apr 2014 17:15:28 +0300
Achilleas Mantzios 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 it,
> especially the migrat
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 tha
On Fri, 11 Apr 2014 09:16:04 -0400
Steve Litt wrote:
> Curious: Why not consider OpenBSD also?
Or NetBSD.
--
D'Arcy J.M. Cain | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner
On Fri, 11 Apr 2014 14:05:43 +0200
Alban Hertroys 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 faster
> of t
On 11 Apr 2014, at 12:39, Achilleas Mantzios
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
>> wrote:
>>> I don't mean to scare the OP, but FreeBSD is not for everyone.
>>
On 11/04/2014 13:05, Alban Hertroys wrote:
On 11 Apr 2014, at 8:04, Achilleas Mantzios
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 administr
On 11 Apr 2014, at 8:04, Achilleas Mantzios
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, as well as the part that
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
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 agre
On Wed, Apr 9, 2014 at 3:36 PM, François Beausoleil
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 like Ubuntu and
On 4 April 2014 11:03, François Beausoleil 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 alleviate some of the
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 pgsql-
c: Christofer C. Bell; pgsql-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
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 th
On Wed, Apr 9, 2014 at 2:56 PM, Steve Atkins wrote:
>
> On Apr 9, 2014, at 1:33 PM, Scott Marlowe wrote:
>
>> On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell
>> wrote:
>>> On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil
>>> wrote:
Hi all!
Does PG perform that much better
On Apr 9, 2014, at 1:33 PM, Scott Marlowe wrote:
> On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell
> wrote:
>> On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil
>> wrote:
>>> Hi all!
>>>
>>> Does PG perform that much better on FreeBSD? I have some performance issues
>>> on a Ubuntu 12.
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 ha
On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell
wrote:
> On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil
> 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
>
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
> 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,
On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil
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 alleviate s
On Fri, Apr 4, 2014 at 12:03 AM, François Beausoleil
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 a week's worth
>
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 w
Le 2014-04-04 à 08:11, Ray Stell a écrit :
>
> On Apr 4, 2014, at 12:03 AM, François Beausoleil 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 n
On Apr 4, 2014, at 12:03 AM, François Beausoleil 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 pressed by some other s
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 curve
On Fri, Apr 4, 2014 at 9:33 AM, François Beausoleil 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 alleviate
> so
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 rand
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
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 off
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 c
> > 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 po
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
-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
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 othe
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
35 matches
Mail list logo
