Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51441=pgsql-performance-ar@postgresql.org>)
 id 1WWvS8-0005QX-Ap
 for pgsql-performance@arkaria.postgresql.org; Sun, 06 Apr 2014 22:22:12 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51441=pgsql-performance-ar@postgresql.org>)
 id 1WWvS7-0004lK-PV
 for pgsql-performance@arkaria.postgresql.org; Sun, 06 Apr 2014 22:22:11 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <niparisco@gmail.com>) id 1WWvS5-0004lB-MD
 for pgsql-performance@postgresql.org; Sun, 06 Apr 2014 22:22:09 +0000
Received: from mail-wi0-x236.google.com ([2a00:1450:400c:c05::236])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <niparisco@gmail.com>) id 1WWvS0-0007jJ-Bp
 for pgsql-performance@postgresql.org; Sun, 06 Apr 2014 22:22:09 +0000
Received: by mail-wi0-f182.google.com with SMTP id d1so4056838wiv.15
 for <pgsql-performance@postgresql.org>; Sun, 06 Apr 2014 15:22:03 -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=buuer/krJzCFvyMNHe/rCBjilgA7hf/uABJYFOCiu80=;
 b=iM5X75PlCaMcv2m03dNYQPFE6WzB2l3dt7tw2ncSBQGqtV5RZ8DyhnqqTZpbiFmj2r
 lEWtblBFFQlLOWbFfRbf41/8Q5M1masz9HoAQCm1+SQzGUcLtp/DHdoOfGhDGVZUEr/R
 DBqVE345ZaRF35GyV/8tsgX4d3cLzEY9uHZNaNj6VTofv9Nlofs5nG6dER1ZZ6DYqNY/
 ldrJskKWegoe5eN2vNhcTwYVl/1DXfsjJ3K2UIggFCGjWFTshe/AQyo2AVbUr4GAJ2RE
 AMviBAEq8Iy97uxb1E4ki8uqX/RcVvBjSJAWzyuR3vbHuy6KZ1MS9YdRnP3PVd3rnkHo
 79Bw==
X-Received: by 10.180.106.134 with SMTP id gu6mr21220723wib.61.1396822923175;
 Sun, 06 Apr 2014 15:22:03 -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 h8sm19829641wiz.12.2014.04.06.15.22.01
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Sun, 06 Apr 2014 15:22:02 -0700 (PDT)
Message-ID: <5341D377.8060309@gmail.com>
Date: Mon, 07 Apr 2014 00:21:43 +0200
From: PARIS Nicolas <niparisco@gmail.com>
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 <thom@linux.com>
CC: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: PGSQL 9.3 - Materialized View - multithreading
References: 
 <CA+ssMOS8kjy+YKMV+hR5VTuLSa-Fd-ADHVgsNBaEaXS44Azwiw@mail.gmail.com>
 <CAA-aLv7S5XtJX-k4jYP1iMQVh3d0+qS7T4EtwZJ8D3zU3pSpiA@mail.gmail.com>
 <533F0CB8.40001@gmail.com>
 <CAA-aLv46JhCAs0QWOBXxk=Vm9-dzGMpFji7irVeFECZ+QniNvw@mail.gmail.com>
 <533F10E6.4010303@gmail.com>
 <CAA-aLv4LkmoV=HuWHSsqya0yak-1B65Px=_Tg4YngXhALu9E2g@mail.gmail.com>
 <533F156E.4000400@gmail.com>
 <CAA-aLv5ekD0WmyTi2po=qTggVjF2K6C4TNFD75M9kHRFb9wKvA@mail.gmail.com>
In-Reply-To: 
 <CAA-aLv5ekD0WmyTi2po=qTggVjF2K6C4TNFD75M9kHRFb9wKvA@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Right, not refering triggers, seems to be kind of mix C/sql compiled  (=
external).
To conclude :
- pl/proxy, it appears difficult, and not designed to.
- pgAgent (supposed to apply jobs in a multithreaded way)
- bash (xargs does the job)
- external scripts (R, python, perl...)

So I will test pgAgent and feedback it


Thanks

Le 06/04/2014 21:07, Thom Brown a écrit :
> On 4 April 2014 21:26, PARIS Nicolas <niparisco@gmail.com> 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...
> 
> That page doesn't refer to triggers at all, so I'm still not sure what you mean.
> 



-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance