Re: configuration according to the database - Mailing list pgsql-general

From Daniel R. Anderson
Subject Re: configuration according to the database
Date
Msg-id 1048301344.8171.17.camel@ny-chicagostreet2c-110.buf.adelphia.net
Whole thread Raw
In response to Re: configuration according to the database  (Neil Conway <neilc@samurai.com>)
List pgsql-general
<snip>
> > If you are looking for speed, I would make the whole thing as arrays in memory
> > in C++, and just do backups to the database on a regular basis.
>
> You'd suggest storing "12 to 15GB" of data in main memory on an x86
> machine with 4GB of RAM?
</snip>

If I remember correctly, Sparc based computers can hold insane amounts
of memory.  They're insanely expensive though; even the decade old ones
on e-bay.  I don't suppose it's possible to RAID (or is it Beowolf?)
enough computers together to get a giant RAM Disk?

--
Daniel R. Anderson
Great Lakes Industries, Inc.
80 Pineview Ave.
Buffalo, NY 14218
(716) 691-5900 x218

"Never let your schooling interfere with your education"
    -- Mark Twain


pgsql-general by date:

Previous
From: P G
Date:
Subject: Re: newbie question: 'multithreading' longrunning postgres-queries from plpgsql-function.
Next
From: Tom Lane
Date:
Subject: Re: 32/64-bit transaction IDs?