X-Original-To: pgsql-performance@postgresql.org Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id E2ACC476128 for ; Tue, 18 Mar 2003 11:26:19 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2908257; Tue, 18 Mar 2003 08:26:12 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Logan Bowers , Tom Lane Subject: Re: postgresql meltdown on PlanetMath.org Date: Tue, 18 Mar 2003 08:26:10 -0800 User-Agent: KMail/1.4.3 Cc: Neil Conway , sean@chittenden.org, pgsql-performance@postgresql.org References: <20030316060125.GD19570@vt.edu> <495.1047882860@sss.pgh.pa.us> In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200303180826.10200.josh@agliodbs.com> X-Archive-Number: 200303/135 X-Sequence-Number: 1433 Logan, > I'm running this db on a celeron 450Mhz with 256MB RAM and a 60GB HDD > (7200 rpm). For the most part I have the db running "well enough." Over Hmmm ... actually, considering your hardware, I'd say the database performance you're getting is excellent. You're facing 3 bottlenecks: 1) The Celeron II's lack of on-chip cache will slow down even moderately complex queries as much as 50% over a comparably-clocked pentium or AMD chip, in my experience. 2) 256mb RAM is small enough that if you are running Apache on the same machine, Apache & Postgres could be contesting for RAM during busy periods. 3) (most noticable) You have pretty much the bare minimum of disk. For a one-gb database, a Linux RAID array or mirror would be a lot better ... Of course, that's all relative. What I'm saying is, if you want your database to "scream" you're going to have to put some money into hardware. If you're just looking for adequate performance, then that can be had with a little tweaking and maintainence. -- Josh Berkus Aglio Database Solutions San Francisco