On 05/11/11 9:04 PM, Tim Uckun wrote:
or carefully structure your dblink joins so they can perform efficiently,
> possibly using temp tables as a sort of materialized view.
According to the documents unless you are writing procedural code with
cursors when you touch the dblink view it will pull the entire
table/recordset over.
well, the idea is, you only query the remote server for the data you
know you'll need. yeah, you can't arbitrarily do complex joins between
large tables, you want to filter as much as you can with the remote
query so the dblink only pulls across data you need. procedures might
help too.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
