Date: Fri, 14 Feb 2014 08:53:50 -0700
From: The Doctor <doctor@doctor.nl2k.ab.ca>
To: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Using BSD/OS with 8.1, 8.4 and 9.3
Message-ID: <20140214155348.GA338@doctor.nl2k.ab.ca>
References: <20140213233203.GA27689@doctor.nl2k.ab.ca>
 <20140214010616.GA3244@momjian.us> <20140214031619.GA29785@doctor.nl2k.ab.ca>
 <20140214143939.GA473@momjian.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20140214143939.GA473@momjian.us>
User-Agent: Mutt/1.5.17 (2007-11-01)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Fri, Feb 14, 2014 at 09:39:39AM -0500, Bruce Momjian wrote:
> On Thu, Feb 13, 2014 at 08:16:19PM -0700, The Doctor wrote:
> > oN tHU, fEb 13, 2014 at 08:06:16PM -0500, Bruce Momjian wrote:
> > > On Thu, Feb 13, 2014 at 04:32:04PM -0700, The Doctor wrote:
> > > > All right, finally compiled more semaphores
> > > > into the server to use more recent and supported PostGRESQL version.
> > > > 
> > > > Odd problem is that 8.1 seems to perfrom better than
> > > > 
> > > > 8.4 compile and 9.3 compiled.
> > > > 
> > > > Question: is their anything I should tweek?
> > > 
> > > Wow, what version of BSD/OS are you using?  We removed BSD/OS support in
> > > Postgres 9.2.  I ran BSD/OS until December 2011.
> > > 
> > > Usually Postgres gets faster so I am unclear why older versions would be
> > > faster.
> > 
> > 4.3.1 using 4GB Ram and 3+ Dual 32-bit XEON CPUs.
> > 
> > I wonder if the configuration has something to do 
> > with the proble,
> 
> Uh, I was not aware of any performance problems when I was running
> BSD/OS.

Well I had to tweak the kernel and add more semaphores.

I also noted the 8.4 and 9.2 compiles were slightly different from the
8.1 compile.

> 
> > BTW for 93. + FreeBSD does well thank you.
> 
> Yeah, we thought I was the only BSD/OS user left on PG, so when I left,
> we removed support for the platform.

No worries.  I am the last holdout looking to port everything to more powerful
FreBSD 9.2 or above server.

I just do not have the money.

> 
> -- 
>   Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>   EnterpriseDB                             http://enterprisedb.com
> 
>   + Everyone has their own god. +

-- 
Member - Liberal International	This is doctor@nl2k.ab.ca Ici doctor@nl2k.ab.ca
God,Queen and country!Never Satan President Republic!Beware AntiChrist rising! 
http://www.fullyfollow.me/rootnl2k  Look at Psalms 14 and 53 on Atheism
He will always be a slave who does not know how to live upon a little.  -Horace  


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin