Re: PostgreSQL DB split

Vivek Khera <khera@kcilink.com>

From: Vivek Khera <khera@kcilink.com>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2007-11-28T15:47:44Z
Lists: pgsql-general
On Nov 28, 2007, at 8:18 AM, Richard Huxton wrote:

>> I can read that I can create a PostgreSQL DB on the RAMDisk  
>> partion, but I'm wondering if is it possible to create
>> one DB with two schemas in two different memory location (RAM and  
>> flash)?
>
> See the manuals for "tablespaces".
>

but postgres will not like it when you restart after a failure and the  
ramdisk tablespace is missing the data postgres expects to be there.