Re: PostgreSQL HardWare

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: Uros Gruber <uros(at)sir-mag(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL HardWare
Date: 2002-01-05 23:47:57
Message-ID: Pine.LNX.4.33.0201051546520.5371-100000@windmill.gghcwest.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 6 Jan 2002, Uros Gruber wrote:

> Hi!
>
> I'm new in postgres so I have one question here. Many of you say that
> you can put database in RAM.
>
> What should i do to tell Postgre to use for example 512MB of RAM an
> put everything in it. What i have to put in config.

This isn't really necessary. On any reasonable operating system, the
kernel will keep disk contents in RAM for fast access. You needn't worry
about it.

If you REALLY insist on doing this, you need to make a filesystem in RAM
and put your databases there. In Linux use the ramdisk driver.

-jwb

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-01-06 00:10:35 Re: Turning off transactions completely.
Previous Message Uros Gruber 2002-01-05 23:17:17 Re: PostgreSQL HardWare