> 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.asc