Re: In memory Database for postgres

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