Greetings, * Ravi Krishna (sravikrishna@xxxxxxxxxxx) wrote: > > Eh, that's something that I think we should be looking at supporting, by > > using FDWs, but I haven't tried to figure out how hard it'd be. > > How good will that be in performance. > > In db2 you can do it using dblinks and that kills performance. isn't FDW something like dblink. > > The cool part is that in SQLServer the optimizer recognizes 3 part name and caching works also. I'm sure there's things we can do to improve the performance of the FDW. Not sure we'll get to a point where we are actually cacheing information from the far side... but who knows, maybe if we arrange to have a notification sent whenever certain objects are updated... These things could be worked on independnetly, of course, no need to have one done before the other. Thanks, Stephen
Attachment:
signature.asc
Description: PGP signature
