PostgreSQL DB split

From: "zanet_tomas\(at)libero\(dot)it" <zanet_tomas(at)libero(dot)it>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL DB split
Date: 2007-11-28 09:07:33
Message-ID: JS7LCL$70EABC4DE0595543D133169B811B695E@libero.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2007-11-28 09:11:21 Re: WAL Recovery
Previous Message Greg Smith 2007-11-28 09:02:59 Re: System Load analyze