Re: [PERFORM] PGSQL 9.3 - Materialized View - multithreading

2014-04-06 Thread PARIS Nicolas
pgAgent and feedback it Thanks Le 06/04/2014 21:07, Thom Brown a écrit : > On 4 April 2014 21:26, 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 stor

Re: [PERFORM] PGSQL 9.3 - Materialized View - multithreading

2014-04-04 Thread PARIS Nicolas
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 mate

Re: [PERFORM] PGSQL 9.3 - Materialized View - multithreading

2014-04-04 Thread PARIS Nicolas
Ok thanks, And what about triggers. 8 triggers based on the same event won't be multithreaded ? Le 04/04/2014 21:57, Thom Brown a écrit : > On 4 April 2014 20:49, PARIS Nicolas wrote: >> Thanks, >> >> "The only thing that immediately comes to mind would b

Re: [PERFORM] PGSQL 9.3 - Materialized View - multithreading

2014-04-04 Thread PARIS Nicolas
Thanks, "The only thing that immediately comes to mind would be running a rather hacky DO function in 4 separate sessions:" You mean 8 sessions I guess. 8 separate sessions ? Have you any idea how to manage sessions ? Is it possible to create separate session internaly ? Do I have to make 8 exte