Re: Performance advice

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance advice
Date: 2003-06-24 09:02:46
Message-ID: 3EF8610E.14606.3CDD813@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2003-06-24 11:33:42 Re: Performance advice
Previous Message Shridhar Daithankar 2003-06-24 08:19:54 Re: Performance advice