Re: [HACKERS] Fwd: Joins and links

> > > Well, I personally dont even know, how I could keep my entire PostgreSQL
> > > DB in RAM :)
> >
> > I thought about doing this once on a Linux box. What I was thinking about was
> > creating a large RAM disk, and use that disk together with a physical drive in
> > a mirror setup. However, I was never able to create a large enough RAM disk back then
[...] 
> Maarten, PostgreSQL keeps it's data in the filesystem, rather than on
> raw disks.  Due to the nature of *nix, all you need to do to keep your
> entire DB in memory is have enough memory.  The buffer cache will do
> the rest, for you.  Of course, you still need to start it up with -F

I know, but there's no *guarantee* that the complete database is going to be in RAM.
That's what I was trying to solve. Putting the thing on a RAM disk would guarantee that
it is.

Maarten

-- 

Maarten Boekhold, boekhold@tibco.com
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com