Re: In memory Database for postgres - Mailing list pgsql-general

From Tomasz Ostrowski
Subject Re: In memory Database for postgres
Date
Msg-id 492E6784.3010205@batory.org.pl
Whole thread Raw
In response to Re: In memory Database for postgres  (Blazej <bl.oleszkiewicz@gmail.com>)
List pgsql-general
On 2008-11-17 23:26, Blazej wrote:

> CREATE TABLESPACE ram_space LOCATION '/mnt/ram0/pgspace';
> And then:
> CREATE TABLE (...) TABLESPACE ram_space;
> and table is in memory.

And when your server will loose power or hang now then your database
will not start after reboot.

I'd rather start a new, temporary database instance on ramdisk.

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                       Winnie the Pooh

pgsql-general by date:

Previous
From: Abdul Rahman
Date:
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
Next
From: Vishal Arora
Date:
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running