X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 552A09DC9E8 for ; Fri, 17 Feb 2006 04:12:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61640-08 for ; Fri, 17 Feb 2006 04:12:41 -0400 (AST) X-Greylist: whitelisted by SQLgrey- Received: from smtp6-g19.free.fr (smtp6-g19.free.fr [212.27.42.36]) by postgresql.org (Postfix) with ESMTP id 2E9E69DC9DE for ; Fri, 17 Feb 2006 04:12:39 -0400 (AST) Received: from imp2-g19.free.fr (imp2-g19.free.fr [212.27.42.2]) by smtp6-g19.free.fr (Postfix) with ESMTP id 2567518197 for ; Fri, 17 Feb 2006 09:12:39 +0100 (CET) Received: by imp2-g19.free.fr (Postfix, from userid 33) id ADBF67ABB0; Fri, 17 Feb 2006 09:12:39 +0100 (MET) Received: from wormhole.x-echo.com (wormhole.x-echo.com [193.252.148.11]) by imp2-g19.free.fr (IMP) with HTTP for ; Fri, 17 Feb 2006 09:12:39 +0100 Message-ID: <1140163959.43f585777f2cc@imp2-g19.free.fr> Date: Fri, 17 Feb 2006 09:12:39 +0100 From: martial.bizel@free.fr To: pgsql-performance@postgresql.org Subject: split partitioned table across several postgres servers References: <1140018930.43f34ef260de0@imp2-g19.free.fr> <1140022257.22740.225.camel@state.g2switchworks.com> In-Reply-To: <1140022257.22740.225.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.5 X-Originating-IP: 193.252.148.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.658 required=5 tests=[AWL=0.108, NO_REAL_NAME=0.55] X-Spam-Score: 0.658 X-Spam-Level: X-Archive-Number: 200602/273 X-Sequence-Number: 17259 Hello, I want to split table partitioned across two servers postgres (two hosts). To query this remote object, I want to make view with union on two servers with two dblink. But, How to be sure that optimizer plan on remote node is same than local node (ie : optimizer scan only the selected partitions and not make full scan of the remote object) ? example : server 1 (table test partionned on field number and 1 < number <10) server 2 (table test partitioned on field number 10 15. optimizer made full scan of all partitions on all servers or scan only partition 1 to partition 4 on server1 and scan partiton 16 to partition 19 on server2 and union ? In fact, I don't know how to have explain plan of remote node. Thanks a lot. MB