Re: [Postgres-xc-general] Questions about Postgres-XC

[鈴木 幸市 <ko...@in...>]

2014/05/29 0:08、Alan Bryant <ala...@hd...<mailto:ala...@hd...>> のメール：


I have a few questions about Postgres-XC that I couldn't find answers to in the documentation or with google searches:

- How does postgres-xc work with extensions, specifically PGQ? Do they work? Where do they "run?" on the data nodes or on the Coordinator?

I’m afraid nobody tested it.   At least, you should build the binary with XC environment.   Some of internal structure is not binary-compatible with PostgreSQL.

They run either on coordinator/datanode, depending upon specific functions.   Basically, only immutable functions run at datanodes.   Others run at coordinators.


- Similarly, how/where do user-defined functions get installed/run?

As mentioned above, immutable functions run at coordinators.   Others run at datanodes.


- And can user-defined functions perform DML and DDL?

Yes.


- Can we shard on schema? (i.e. put some schemas in one location and other schemas in different locations, sharded the same way rows are?) Or if not, can we shard one table, and have functions execute on the same node as some controlling row?

No.

Thank you;
—
Koichi Suzuki


Thanks,
-Alan

------------------------------------------------------------------------------
Time is money. Stop wasting it! Get your web API in 5 minutes.
www.restlet.com/download<http://www.restlet.com/download>
http://p.sf.net/sfu/restlet_______________________________________________
Postgres-xc-general mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general