Re: large queries

Martin Gregorie wrote:
> I'm using Postgres 7.3, its matching JDBC driver and Java 6.05. The
> machine isn't big: 512 MB RAM, 866 MHz and running Fedora 8.

BTW, that's a rather old version of PG.  Apparently there have been 
significant improvements since then.  On the Postgres boards they don't
even 
regard version 7.4 as sufficiently current.

Also, PG is fully capable of using much more horsepower if you make it 
available.  I routinely read about RAID arrays and multi-GB database
servers 
for PG.  If one is truly doing large queries, they might find 512 MB a
little 
skinny for the need.

One more advice: if data integrity is worth something to you, either turn
of 
write-back caching, or use a battery-backed RAID controller.  If you
suffer a 
crash before things are fully written to the drive from the cache it could

seriously fubar your data.

-- 
Lew