Re: Query

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
Thread:
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.

In response to

  • Query at 2007-04-09 14:02:10 from Shaunak Godbole

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Saito 2007-04-12 08:14:06 Re: Vista/IPv6
Previous Message Csaba Nagy 2007-04-12 08:03:46 Re: Last chance to object to MVCC-safe CLUSTER