Re: PostgreSQL DB split

zanet_tomas(at)libero(dot)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