From: | "Rivera Alejandro" <arivera(at)conectum(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Postgres & CODA |
Date: | 2006-07-04 16:40:59 |
Message-ID: | C2D2EA3B0BDF5746BB2EA541DC77CF4E01911B82@posmex_ml01.corporativo.posadas.com.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've been reading a lot of documentation trying to find a way to implement a Postgres database on CODA and get it distributed that way. Unfortunately, I found out that CODA apparently doesn't support concurrency over databases, so i came up with an idea of using files, each file containing a single record, so the 2PL locks could be applied to a certain "record-file".
This project will use a global directory with the information about the "fragments" and their location. A fragment would consist of a collection of record-files in a coda volume(directory).
So my question would be: ¿Is there a way to make a single record dump of a given table to a file?, the fact is that I need an horizontal fragmentation, record by record, so ¿how would you do it?
I know this might seem a little nuts, but i would like to get your views on this idea.
Please tell me if I'm just wasting my time hehehehehe :)
Alex Rivera.
PD: please forgive any mispelled words...
Alejandro Rivera Polanco
Base de Datos
1131300 (ext. 3375) - 1131375
arivera(at)conectum(dot)net
Grupo Posadas
Te invitamos a conocer el nuevo Fiesta Inn Reynosa, donde descansa la gente que trabaja.
From | Date | Subject | |
---|---|---|---|
Next Message | Sandro Dentella | 2006-07-04 18:30:14 | How to bypass perm pb on information schema. Request of review |
Previous Message | Joshua D. Drake | 2006-07-04 16:18:25 | Re: RAID + PostgreSQL? |