Re: [HACKERS] Fwd: Joins and links

From: Maarten Boekhold <boekhold(at)tibco(dot)com>
To: Hannu Krosing <hannu(at)trust(dot)ee>
Cc: Leon <leon(at)udmnet(dot)ru>, hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Fwd: Joins and links
Date: 1999-07-12 07:56:54
Message-ID: 37899FC6.257F31CB@tibco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hannu Krosing wrote:
> Leon wrote:

> > Frankly, I didn't even consider fetching database from disk. This
> > slows queries immensely and I wonder if there exist someone who
> > doesn't keep their entire DB in RAM.
>
> 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
(must have been like LInux 2.0), and also the RAID mirror code wasn't able to
support such a mix of devices (i.e. RAM disk + physical disk). The situation might
have changed by now.

Maarten

--

Maarten Boekhold, boekhold(at)tibco(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message John Ridout 1999-07-12 09:09:51 RE: [HACKERS] Updated TODO list
Previous Message Oleg Bartunov 1999-07-12 07:19:28 Re: [HACKERS] 6.5.1 release date