| From: | Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl> |
|---|---|
| To: | Blazej <bl(dot)oleszkiewicz(at)gmail(dot)com> |
| Cc: | avin_friends(at)yahoo(dot)com, postgresql Forums <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: In memory Database for postgres |
| Date: | 2008-11-27 09:25:24 |
| Message-ID: | 492E6784.3010205@batory.org.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vishal Arora | 2008-11-27 12:27:26 | Re: PgAgent Job Scehduler is NOT running |
| Previous Message | Willy-Bas Loos | 2008-11-27 08:36:36 | Re: Separate Sessions?? (View data <-> Query tool) |