Postgres Pro
Downloads
Home   >   mailing lists

select from dblink very slow - Mailing list pgsql-admin

From Jessica Richard
Subject select from dblink very slow
Date
Msg-id 267133.52846.qm@web56415.mail.re3.yahoo.com
Whole thread Raw
Responses Re: select from dblink very slow  (Joe Conway <mail@joeconway.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: select count(*) from a large table is very slow
Next
From: "Jonah H. Harris"
Date:
Subject: Re: select count(*) from a large table is very slow