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.
...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
Winnie the Pooh
In response to
pgsql-general by date
|Next:||From: Vishal Arora||Date: 2008-11-27 12:27:26|
|Subject: Re: PgAgent Job Scehduler is NOT running|
|Previous:||From: Willy-Bas Loos||Date: 2008-11-27 08:36:36|
|Subject: Re: Separate Sessions?? (View data <-> Query tool)|