Re: PostgreSQL DB split - Mailing list pgsql-general

From Richard Huxton
Subject Re: PostgreSQL DB split
Date
Msg-id 474D6ABD.9020508@archonet.com
Whole thread Raw
In response to PostgreSQL DB split  ("zanet_tomas\@libero\.it" <zanet_tomas@libero.it>)
Responses Re: PostgreSQL DB split  (Vivek Khera <khera@kcilink.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: [Re] Re: [Re] Re: Unknown winsock error 10061while dumping a big database
Next
From: Simon Riggs
Date:
Subject: Press contacts