pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (39+ messages)  latest in thread

Message-ID: <200303180826.10200.josh@agliodbs.com>
Permalink:  ../200303180826.10200.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200303180826.10200.josh@agliodbs.com

 · 

reply

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