dblink without running the full query remotely?
От
Wells Oliver
Тема
dblink without running the full query remotely?
Дата
Msg-id
CAOC+FBWCx3iunwdXYRKmr89O2qXNeOHgSTvv13Cju73LNcvKEA@mail.gmail.com
Список
Дерево обсуждения
dblink without running the full query remotely? Wells Oliver <wells.oliver@gmail.com>
Re: dblink without running the full query remotely? Tom Lane <tgl@sss.pgh.pa.us>
Re: dblink without running the full query remotely? Wells Oliver <wells.oliver@gmail.com>
Re: dblink without running the full query remotely? M Sarwar <sarwarmd02@outlook.com>
Per the documentation -- dblink fetches the entire remote query result before returning any of it to the local system -- I am guessing the answer is no, but I wondered if there was some way to do something like this:
create view myview as;
select * from dblink(
'server',
'select id from sometable')
cols(id bigint);
And then
select * from dblink(
'server',
'select id from sometable')
cols(id bigint);
And then
select * from myview where id = 123;
Where that remote sometable might have a bajillion rows and the local where would be passed to it otherwise it's days and days for all rows to be returned and then filtered.
В списке pgsql-admin по дате отправления
