Re: PostgreSQL DB split

zanet_tomas@libero.it wrote:
> Hi,
> 
> I'm currently using a PostgreSQL DB on my disk memory, but right now I need to split this DB in this way:
> 
> 	a. the first DB (or first DB partion) will be stored in the Flash memory and it will contain the system configuration values;
> 	b. the second DB (or second DB partion) will be stored in the RAM memory and it will contain the state values.
> 	   These values will be modified many times and they will be deleted when the system goes down.
> 
> 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".


-- 
   Richard Huxton
   Archonet Ltd