Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WWApH-0006yC-4x for pgsql-performance@arkaria.postgresql.org; Fri, 04 Apr 2014 20:34:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WWApG-0004YC-Gk for pgsql-performance@arkaria.postgresql.org; Fri, 04 Apr 2014 20:34:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WWApF-0004Y6-PB for pgsql-performance@postgresql.org; Fri, 04 Apr 2014 20:34:57 +0000 Received: from proofpoint2.mail.rice.edu ([128.42.201.101] helo=pp2.rice.edu) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WWApA-0005Is-Qe for pgsql-performance@postgresql.org; Fri, 04 Apr 2014 20:34:57 +0000 Received: from pps.filterd (pp2.rice.edu [127.0.0.1]) by pp2.rice.edu (8.14.5/8.14.5) with SMTP id s34KW1Li028145; Fri, 4 Apr 2014 15:34:47 -0500 Received: from mh10.mail.rice.edu (mh10.mail.rice.edu [128.42.201.30]) by pp2.rice.edu with ESMTP id 1k1xyq87fa-1; Fri, 04 Apr 2014 15:34:47 -0500 X-Virus-Scanned: by amavis-2.7.0 at mh10.mail.rice.edu, auth channel X-SMTP-Auth: no X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh10.mail.rice.edu (Postfix) with ESMTP id A689C602F1; Fri, 4 Apr 2014 15:34:46 -0500 (CDT) Received: by aart.rice.edu (Postfix, from userid 18612) id 9E4DF100681; Fri, 4 Apr 2014 15:34:46 -0500 (CDT) Date: Fri, 4 Apr 2014 15:34:46 -0500 From: "ktm@rice.edu" To: PARIS Nicolas Cc: Thom Brown , pgsql-performance Subject: Re: PGSQL 9.3 - Materialized View - multithreading Message-ID: <20140404203446.GG25879@aart.rice.edu> References: <533F0CB8.40001@gmail.com> <533F10E6.4010303@gmail.com> <533F156E.4000400@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <533F156E.4000400@gmail.com> User-Agent: Mutt/1.5.20 (2009-12-10) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 kscore.is_bulkscore=2.22044604925031e-16 kscore.compositescore=0 circleOfTrustscore=0 compositescore=0.35634480905857 urlsuspect_oldscore=0.0553703525497916 suspectscore=0 recipient_domain_to_sender_totalscore=0 phishscore=0 bulkscore=0 kscore.is_spamscore=0 recipient_to_sender_totalscore=0 recipient_domain_to_sender_domain_totalscore=0 rbsscore=0.35634480905857 spamscore=0 recipient_to_sender_domain_totalscore=0 urlsuspectscore=0.9 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=7.0.1-1402240000 definitions=main-1404040188 X-Pg-Spam-Score: -2.5 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On Fri, Apr 04, 2014 at 10:26:22PM +0200, PARIS Nicolas wrote: > this postgres documentation : > http://www.postgresql.org/docs/9.3/static/ecpg-connect.html > says it is actually possible to manage connection in C stored procedure. > > I may be wrong... > > > Le 04/04/2014 22:14, Thom Brown a écrit : > > lear on how triggers come into this. You can't have triggers > > on materialized views, and they don't fire triggers on tables or views > > that they are based o > Hi, I do not know if it can be used in this fashion, but could pl/proxy be used by defining a cluster to be the same server and use a partitioned remote call? Someone with pl/proxy experience may have more information. Regards, Ken -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance