Re: How to run in parallel in Postgres, EXECUTE_PARALLEL

2019-12-08 Thread Lars Aksel Opsahl
> From: Joe Conway > Sent: Sunday, December 8, 2019 9:04 PM > To: Lars Aksel Opsahl; Laurenz Albe; pgsql-performance@lists.postgresql.org > Subject: Re: How to run in parallel in Postgres, EXECUTE_PARALLEL > > On 12/8/19 1:14 PM, Lars Aksel Opsahl wrote: > > Do you

Re: How to run in parallel in Postgres, EXECUTE_PARALLEL

2019-12-08 Thread Joe Conway
On 12/8/19 1:14 PM, Lars Aksel Opsahl wrote: > Do you or anybody know if there are any plans for a function call that > support the calling structure below or something like it and that then > could finish in 1 second ? (If you are calling a void function, the > return value should not be any probl

Re: How to run in parallel in Postgres, EXECUTE_PARALLEL

2019-12-08 Thread Lars Aksel Opsahl
>You cannot run several queries in parallel in a PostgreSQL function. > >You may want to have a look at PL/Proxy which might be used for things like >that. > >Yours, >Laurenz Albe >-- >Cybertec | https://www.cybertec-postgresql.com Hi Laurenz The code below takes 3, seconds DO $body$ DECLARE