Date: Thu, 11 Oct 2001 09:49:41 -0500 From: Len Conrad <LConrad@Go2France.com> To: freebsd-isp@freebsd.org Subject: Re: PostgreSQL & shared memory Message-ID: <5.1.0.14.0.20011011094458.04e82840@mail.Go2France.com> In-Reply-To: <3BC593CE.FCD09FCA@coi.de> References: <006001c1516b$db2637b0$8d01a8c0@gastroleader.com>
next in thread | previous in thread | raw e-mail | index | archive | help
> > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5.1.0.14.0.20011011094458.04e82840>