Thread

1. PostgreSQL DB split

   zanet_tomas@libero.it <zanet_tomas@libero.it> — 2007-11-28T09:07:33Z

   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)? 
   
   Otherwise, I can create two DBs in two different location (RAM and flash) but is it possible to execute a SQL query 
   where the join relationship concerns two tables located in the different DBs? Can I use the dblink in order to create 
   only one DB connection?
   
   
   Can someone help me? Thanks in advance.
   
   --Tomas
   
   
   

2. Re: PostgreSQL DB split

   Richard Huxton <dev@archonet.com> — 2007-11-28T13:18:53Z

   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
   
   

3. Re: PostgreSQL DB split

   Vivek Khera <khera@kcilink.com> — 2007-11-28T15:47:44Z

   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.