Re: split partitioned table across several postgres servers - Mailing list pgsql-performance

From Tom Lane
Subject Re: split partitioned table across several postgres servers
Date
Msg-id 9163.1140187745@sss.pgh.pa.us
Whole thread Raw
In response to split partitioned table across several postgres servers  (martial.bizel@free.fr)
Responses Re: split partitioned table across several postgres servers  (martial.bizel@free.fr)
List pgsql-performance
martial.bizel@free.fr writes:
> In fact, I don't know how to have explain plan of remote node.

You send it an EXPLAIN.

You can *not* use a view defined as you suggest if you want decent
performance --- the dblink functions will fetch the entire table
contents and the filtering will be done locally.  You'll need to
pass the WHERE conditions over to the remote servers, which more
or less means that you have to give them to the dblink functions
as text.

            regards, tom lane

pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: [HACKERS] qsort again (was Re: Strange Create
Next
From: martial.bizel@free.fr
Date:
Subject: Re: split partitioned table across several postgres servers