Lists: | pgsql-hackers |
---|
From: | "Shaunak Godbole" <shaunak(dot)godbole(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Query |
Date: | 2007-04-09 14:02:10 |
Message-ID: | c51e33740704090702t5d020b7bh54bdbdad5757cb8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hi,
As a part of my university project, I am trying to modify the postgres code
to support parallel system.
As the first step I have partitioned the data on different processors. And
have kept a master node to process all the query requests. Whenever my
master node is queried I need to push my query onto the backend processors.
For this I need a way of connect to different backends via my master node's
backend.
I have tried different functions like:
do_connect
SendQuery
PQconnectdb
etc.
But all of them give the same compilation error of not being able to find
the reference to the functions. Now if I include command.o and
common.opresent in src/bin/psql, I get the error of not referencing
other functions.
I there a way of accessing other backends through the master backend.
Thanks & Regards,
Shaunak Godbole
--
It is not the aptitude but the attitude that decides a persons altitude
Shaunak Godbole
Senior Undergraduate
Computer Science Dept.
IIT Powai, Mumbai 400076
Ph no: +91 98695 41960
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Shaunak Godbole" <shaunak(dot)godbole(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Query |
Date: | 2007-04-09 14:56:50 |
Message-ID: | 27995.1176130610@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
"Shaunak Godbole" <shaunak(dot)godbole(at)gmail(dot)com> writes:
> I there a way of accessing other backends through the master backend.
It seems you're trying to reinvent contrib/dblink.
regards, tom lane
From: | Hannu Krosing <hannu(at)skype(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Shaunak Godbole <shaunak(dot)godbole(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Query |
Date: | 2007-04-09 16:17:45 |
Message-ID: | 1176135466.3297.16.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Ühel kenal päeval, E, 2007-04-09 kell 10:56, kirjutas Tom Lane:
> "Shaunak Godbole" <shaunak(dot)godbole(at)gmail(dot)com> writes:
> > I there a way of accessing other backends through the master backend.
>
> It seems you're trying to reinvent contrib/dblink.
Or you may want to use pl/proxy
( https://developer.skype.com/SkypeGarage/DbProjects/PlProxy ) which can
be used for data partitioning between different hosts/backends if the
interface to data is postgresql functions.
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
--
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia
Skype me: callto:hkrosing
Get Skype for free: http://www.skype.com
From: | nagsid <nags(at)it(dot)iitb(dot)ac(dot)in> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Query |
Date: | 2007-04-12 08:11:42 |
Message-ID: | 9954956.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hi,
As a part of my university project, I am trying to modify the postgres code
to support parallel system.
As the first step I have partitioned the data on different processors. And
have kept a master node to process all the query requests. Whenever my
master node is queried I need to push my query onto the backend processors.
For this I need a way of connect to different backends via my master node's
backend.
I have tried different functions like:
do_connect
SendQuery
PQconnectdb
etc.
But all of them give the same compilation error of not being able to find
the reference to the functions. Now if I include command.o and
common.opresent in src/bin/psql, I get the error of not referencing
other functions.
I there a way of accessing other backends through the master backend.
Thanks & Regards,
Shaunak Godbole
dblink is written specially for remote database access and is efficiently
written for postgresql and is also having async query capabilities, u may
check dblink_connect, dblink_fetch, dblink_exec, dblink_send_query, etc
..... more than that it is also having replication mechanism which u can
achieve using dblink_build_sql_insert, dblink_build_sql_delete,
dblink_build_sql_update which i think would be of utmost help if there is
some replication requirement in ur parallel database system
regards
nags
IIT Bombay
--
View this message in context: http://www.nabble.com/Query-tf3547482.html#a9954956
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.