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.
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