Re: Parallel queries in single transaction

2018-07-16 Thread Paul Muntyanu
f failure), makes things more complex. Indeed I still agree that it is possible to workaround by operating on application level. -P -P On Mon, Jul 16, 2018 at 2:28 PM Tomas Vondra wrote: > > > On 07/16/2018 12:03 PM, Paul Muntyanu wrote: > > Hi Tomas, thanks for looking into. I am mo

Re: Parallel queries in single transaction

2018-07-16 Thread Paul Muntyanu
single query running) == 6 cores are occupied. If I can run queries in parallel, I would occupy two IO stacks(two tablespaces) + 12 cores instead of sequentially 6 and then again 6. Hope that makes sense -P On 16 Jul 2018, at 11:44, Tomas Vondra wrote: Hi, On 07/16/2018 09:45 AM, Paul Muntyanu

Parallel queries in single transaction

2018-07-16 Thread Paul Muntyanu
Hello, I am working with data warehouse based on postgresql and would like to propose a feature. The idea is to give control and ability for developer to execute queries in parallel within single transaction. Usual flow is next: START_TRANSACTION -> QUERY1 -> QUERY2 -> QUERY3 -> END_TRANSACTION