select from dblink very slow

Поиск
Список
Период
Сортировка
От Jessica Richard
Тема select from dblink very slow
Дата
Msg-id 267133.52846.qm@web56415.mail.re3.yahoo.com
обсуждение исходный текст
Ответы Re: select from dblink very slow  (Joe Conway <mail@joeconway.com>)
Список pgsql-admin
I need to joint select from table A in the current database A and dblink to table B in database B, the result coming from tableB in db B is very slow because I have to select all the rows from tableB from dblink then do "where" with table A in the current db....doing dblink this way is very very slow....

Any idea on how to improve this?

Thanks,
Jessica


Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: select count(*) from a large table is very slow
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: select count(*) from a large table is very slow