Re: Custom Plan node

On Sat, Sep 07, 2013 at 05:21:31PM +0200, Kohei KaiGai wrote:
> 2013/9/7 David Fetter <david(at)fetter(dot)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 <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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