On Sat, Sep 07, 2013 at 05:21:31PM +0200, Kohei KaiGai wrote: > 2013/9/7 David Fetter <da...@fetter.org>: > > The broad outlines look great. > > > > Do we have any way, at least conceptually, to consider the graph > > of the cluster with edges weighted by network bandwidth and > > latency? > > > As postgres_fdw is now doing? Its configuration allows to add cost > to connect remote server as startup cost, and also add cost to > transfer data on network being multiplexed with estimated number of > rows, according to per-server configuration. I think it is > responsibility of the custom plan provider, and fully depends on the > nature of what does it want to provide.
Interesting :) Sorry I was unclear. I meant something that could take into account the bandwidths and latencies throughout the graph, not just the connections directly from the originating node. Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
