From: Josh Berkus <josh@agliodbs.com>
To: Logan Bowers <logan@datacurrent.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Neil Conway <neilc@samurai.com>
Cc: sean@chittenden.org
Cc: pgsql-performance@postgresql.org
Subject: Re: postgresql meltdown on PlanetMath.org
Date: Tue, 18 Mar 2003 08:26:10 -0800
Message-ID: <200303180826.10200.josh@agliodbs.com> (raw)
In-Reply-To: <Pine.LNX.4.53.0303171845190.8636@neo.magick.org>
References: <20030316060125.GD19570@vt.edu>
<495.1047882860@sss.pgh.pa.us>
<Pine.LNX.4.53.0303171845190.8636@neo.magick.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, logan@datacurrent.com, tgl@sss.pgh.pa.us, neilc@samurai.com, sean@chittenden.org
Subject: Re: postgresql meltdown on PlanetMath.org
In-Reply-To: <200303180826.10200.josh@agliodbs.com>
References: <20030316060125.GD19570@vt.edu> <495.1047882860@sss.pgh.pa.us> <Pine.LNX.4.53.0303171845190.8636@neo.magick.org> <200303180826.10200.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox