From: Rod Taylor <rbt@rbt.ca>
To: Mike Glover <mpg4@duluoz.net>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: RAID or manual split?
Date: Tue, 17 Feb 2004 17:17:15 -0500
Message-ID: <1077056235.18564.207.camel@jester> (raw)
In-Reply-To: <20040217135342.1924326f.mpg4@duluoz.net>
References: <20040217135342.1924326f.mpg4@duluoz.net>
> There are frequent (100-1000/day) queries of both the
> inventory and summary tables using the primary key -- always using the
> index and returning < 10 rows.
For this query frequency I don't think splitting the drives will do much
-- you just need more IO. Look at optimizing the query themselves,
specifically ensuring the useful information is already in memory.
If the 10 rows are recent, you might try using partial indexes with the
last days worth of information instead of an index across the entire
table.
> We're currently getting (barely) acceptable performance from a single
> 15k U160 SCSI disk, but db size and activity are growing quickly.
> I've got more disks and a battery-backed LSI card on order.
Configure for Raid 10 and you're off.
--
Rod Taylor <rbt [at] rbt [dot] ca>
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
PGP Key: http://www.rbt.ca/signature.ascAttachments:
signature.asc (application/pgp-signature, 186B) download
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rbt@rbt.ca, mpg4@duluoz.net
Subject: Re: RAID or manual split?
In-Reply-To: <1077056235.18564.207.camel@jester>
* 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