Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WWAhB-0006jX-DI for pgsql-performance@arkaria.postgresql.org; Fri, 04 Apr 2014 20:26:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WWAhA-0007C5-Oj for pgsql-performance@arkaria.postgresql.org; Fri, 04 Apr 2014 20:26:36 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WWAh9-0007By-Hv for pgsql-performance@postgresql.org; Fri, 04 Apr 2014 20:26:35 +0000 Received: from mail-wi0-x234.google.com ([2a00:1450:400c:c05::234]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WWAh6-00037T-4r for pgsql-performance@postgresql.org; Fri, 04 Apr 2014 20:26:34 +0000 Received: by mail-wi0-f180.google.com with SMTP id q5so1965286wiv.13 for ; Fri, 04 Apr 2014 13:26:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=CaLgljzsQJ/ijax08ka/KbPaps/2D2fqScek7puU6kE=; b=vO6uOWQLmgmSdBO67QCptl3+bSeCE9pCPFcgZXsInVqRlQ0uLrZlnwGYXMXQT0VPTr 0lcYPTdsaXonkNmTogQg9p397+0f+YOJdcKIEi61u4xZZ3CwknPfGRfIfsM4hAAxyX32 Zq3iuUwoTMf1zaGoIqg9vJtnwpDPT33oTLi9by99LFsmebJMnMq/Tp48b86G6LS6uE1W CmaXhWQtlYBRc19EqDc+RZn07Lvr/PCyUfwuXjrRnxjyYpONRCEc2wfnbqmyHeZBrpgq aYVcevYkjQJka4Uuz3V60vcgEqPLQuJgpxG/HBTODO4FUTLVHokRV69Q8vtzPnoihcfP T6GQ== X-Received: by 10.180.80.37 with SMTP id o5mr7194228wix.60.1396643191152; Fri, 04 Apr 2014 13:26:31 -0700 (PDT) Received: from [192.168.1.30] (96.84.15.109.rev.sfr.net. [109.15.84.96]) by mx.google.com with ESMTPSA id mw3sm6666846wic.7.2014.04.04.13.26.29 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 04 Apr 2014 13:26:30 -0700 (PDT) Message-ID: <533F156E.4000400@gmail.com> Date: Fri, 04 Apr 2014 22:26:22 +0200 From: PARIS Nicolas User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To: Thom Brown CC: pgsql-performance Subject: Re: PGSQL 9.3 - Materialized View - multithreading References: <533F0CB8.40001@gmail.com> <533F10E6.4010303@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -2.0 (--) 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 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance