Re:Re: ERROR: XX000: cannot update SecondarySnapshot during a parallel operation

2019-03-15 Thread fuzk
When I set max_parallel_workers_per_gather=0, the select statement can execute successfully. The problem has been solved. Thank you all very much. Alan At 2019-03-14 22:29:24, "Adrian Klaver" wrote: >On 3/13/19 10:54 PM, fuzk wrote: >> Dear Adrian, >> >> My setting is as following. >> >

Re:Re: ERROR: XX000: cannot update SecondarySnapshot during a parallel operation

2019-03-14 Thread fuzk
Dear Adrian, My setting is as following. max_parallel_workers_per_gather=32 I am looking forward to hearing from you. Many thanks Alan. At 2019-03-13 22:31:11, "Adrian Klaver" wrote: >On 3/12/19 7:54 PM, fuzk wrote: >> Dear Sir/Madam >> >> I got an error when I execute the followi