Date: Fri, 12 Oct 2001 09:04:44 +1000 (EST) From: Colin Campbell <sgcccdc@citec.qld.gov.au> To: Len Conrad <LConrad@Go2France.com> Cc: <freebsd-isp@FreeBSD.ORG> Subject: Re: PostgreSQL & shared memory Message-ID: <Pine.BSF.4.33.0110120903100.19490-100000@guru.citec.qld.gov.au> In-Reply-To: <5.1.0.14.0.20011011094458.04e82840@mail.Go2France.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi, On Thu, 11 Oct 2001, Len Conrad wrote: > > > > 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. That was my feeling. If the machine started to swap, there isn't enough memory. Given that it's dirt cheap at the moment (I can get 256MB for A$55.00) I'd be loading the box with heaps of memory. You do not want the box to swap. Colin -- Colin Campbell Unix Support/Postmaster/Hostmaster CITEC +61 7 3006 4710 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?Pine.BSF.4.33.0110120903100.19490-100000>