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
configurationvalues; 
>     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