pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: Performance advice
Date: Tue, 24 Jun 2003 14:32:46 +0530
Message-ID: <3EF8610E.14606.3CDD813@localhost> (raw)
In-Reply-To: <Pine.LNX.4.44.0306241140410.10640-100000@matrix.gatewaynet.com>
References: <3EF85702.30194.3A69859@localhost>

On 24 Jun 2003 at 12:10, Achilleus Mantzios wrote:

> On Tue, 24 Jun 2003, Shridhar Daithankar wrote:
> > With java runnning on same machine, I would not trust that machine for having 
> > free RAM all the time, no matter how much RAM you have put into it.
> 
> There are always the -Xmx, -Xss, -Xms jvm switches,
> to control stack (per thread) and heap sizes.

OK. I am not familiar with any of them. Are they related to java? Have never 
worked on java myself.

I was talking about OOM killer behaviour, which was beaten to death for last 
few days..

> > For both these reasons, I suggest you put your database on another machine. A 
> > dual CPU machine is more than enough. Put good deal RAM, around a GB and two 
> > SCSI disks, one for data and another for WAL. If you get RAID for data, great. 
> > But that should suffice otherwise as well.
> > 
> 
> I think the DB on another machine could be from something helpfull,
> to an overkill, to a leg self shooting.
> Depending on the type of the majority of queries and the network speed
> someone should give an extra time to think about it.

I agree. but with the input provided, I think that remains as viable option.

> > And for that you got to try freeBSD. That would gave you plenty of idea about 
> > performance differences. ( Especially I love man hier and man tuning on 
> > freeBSD. Nothing on linux comes anywhere near to that)
> > 
> 
> Its like comparing Mazda with VVT-i.

What are they? My guess is they are cars., Anyway,  I drive a tiny utility bike 
in far country like India..:-)

> Whould you expect to find the furniture fabric
> specs in the main engine manual?

Well, I agree they are different but not that much..:-) And  besides man tuning 
is much more helpful w.r.t. tuning a box. I still think it is relevant. and 
that was just one example why freeBSD is better server OS, out of the box, 
compared to linux.

No flame wars.. Peace..


Bye
 Shridhar

--
Lieberman's Law:	Everybody lies, but it doesn't matter since nobody listens.




view thread (23+ messages)  latest in thread

Message-ID: <3EF8610E.14606.3CDD813@localhost>
Permalink:  ../3EF8610E.14606.3CDD813@localhost/
Also on:    postgresql.org/message-id/3EF8610E.14606.3CDD813@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: shridhar_daithankar@persistent.co.in
  Subject: Re: Performance advice
  In-Reply-To: <3EF8610E.14606.3CDD813@localhost>
  References: <3EF85702.30194.3A69859@localhost> <3EF8610E.14606.3CDD813@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox