Re: PGSQL 9.3 - Materialized View - multithreading

From: PARIS Nicolas <niparisco(at)gmail(dot)com>
To: Thom Brown <thom(at)linux(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PGSQL 9.3 - Materialized View - multithreading
Date: 2014-04-06 22:21:43
Message-ID: 5341D377.8060309@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)gmail(dot)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.
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Varadharajan Mukundan 2014-04-07 02:34:20 Re: Slow Count-Distinct Query
Previous Message Thom Brown 2014-04-06 19:07:41 Re: PGSQL 9.3 - Materialized View - multithreading