From: Tom Lane <tgl@sss.pgh.pa.us>
To: martial.bizel@free.fr
Cc: pgsql-performance@postgresql.org
Subject: Re: split partitioned table across several postgres servers
Date: Fri, 17 Feb 2006 09:49:05 -0500
Message-ID: <9163.1140187745@sss.pgh.pa.us> (raw)
In-Reply-To: <1140163959.43f585777f2cc@imp2-g19.free.fr>
References: <1140018930.43f34ef260de0@imp2-g19.free.fr>
<1140022257.22740.225.camel@state.g2switchworks.com>
<1140163959.43f585777f2cc@imp2-g19.free.fr>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, martial.bizel@free.fr
Subject: Re: split partitioned table across several postgres servers
In-Reply-To: <9163.1140187745@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox