From owner-freebsd-isp Thu Oct 11 7:50:23 2001 Delivered-To: freebsd-isp@freebsd.org Received: from mgw1.MEIway.com (mgw1.meiway.com [212.73.210.75]) by hub.freebsd.org (Postfix) with ESMTP id A38A237B401 for ; Thu, 11 Oct 2001 07:50:20 -0700 (PDT) Received: from mail.Go2France.com (ms1.meiway.com [212.73.210.73]) by mgw1.MEIway.com (Postfix Relay Hub) with ESMTP id 90AEE16B1E for ; Thu, 11 Oct 2001 16:50:18 +0200 (CEST) Received: from IBM-HIRXKN66F0W.Go2France.com [66.64.14.18] by mail.Go2France.com with ESMTP (SMTPD32-6.06) id A4925871007E; Thu, 11 Oct 2001 17:02:42 +0200 Message-Id: <5.1.0.14.0.20011011094458.04e82840@mail.Go2France.com> X-Sender: LConrad@Go2France.com@mail.Go2France.com X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Thu, 11 Oct 2001 09:49:41 -0500 To: freebsd-isp@freebsd.org From: Len Conrad Subject: Re: PostgreSQL & shared memory In-Reply-To: <3BC593CE.FCD09FCA@coi.de> References: <006001c1516b$db2637b0$8d01a8c0@gastroleader.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org > > In fact we moved the site from a Win2k/iis/sqlserver to BSD, and we have a > > HUGE amount of hits, and the machine is already getting overloaded. > > PostgreSQL seems like a ressource hog. The machine is a bi-PIII 866Mhz, > > 380Mb RAM, Adaptec 2100s. 380 Mb of RAM for a "huge hits" MS SQL machine is way under spec'ed. It's a joke. 1 gb would be comfortable for MS SQL, esp since memory is so cheap now. You should be running x SQL on a dedicated backend server, anyway, rather than on a busy web server. 380 mb for IIS+MSSQL is pretty silly. MS SQL should start with a 512 mb machine all to itself. Len http://MenAndMice.com/DNS-training http://BIND8NT.MEIway.com : ISC BIND 8.2.4 for NT4 & W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail gateways To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message