Re: Trying to the behavior of a parallel query with with a change in the transaction isolation mode

2018-02-13 Thread Luis Carril
; COMMIT; BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, READ ONLY; EXPLAIN ANALYZE EXECUTE st; COMMIT; DEALLOCATE st; Cheers, Luis M From: Alvaro Herrera Sent: Monday, February 12, 2018 4:19:52 PM To: Luis Carril Cc: pgsql-gene...@postgresql.org Subject: Re

Trying to the behavior of a parallel query with with a change in the transaction isolation mode

2018-02-12 Thread Luis Carril
Hi all, I am trying to verify if during a transaction a parallel plan ca be generated but later only a sequential one is executed. The documentation says the following (in https://www.postgresql.org/docs/9.6/static/when-can-parallel-query-be-used.html): --- Even when parallel query