X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id AC20D30F89A for ; Tue, 24 Jun 2003 09:03:44 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 58020-10 for ; Tue, 24 Jun 2003 06:03:34 -0300 (ADT) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 6593330F7A0 for ; Tue, 24 Jun 2003 06:03:32 -0300 (ADT) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h5O93WN31571 for ; Tue, 24 Jun 2003 14:33:32 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h5O93VH31566 for ; Tue, 24 Jun 2003 14:33:32 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Tue, 24 Jun 2003 14:32:46 +0530 MIME-Version: 1.0 Subject: Re: Performance advice Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3EF8610E.14606.3CDD813@localhost> References: <3EF85702.30194.3A69859@localhost> In-reply-to: X-mailer: Pegasus Mail for Windows (v4.02) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Archive-Number: 200306/139 X-Sequence-Number: 2223 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.