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,
>>
>
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
Dear Sir/Madam
I got an error when I execute the following select sentence.
Would you please solve the problem for me?
Thank you .
Alan Fu.
postgres=# \set VERBOSITY verbose
postgres=# SELECT
round(cast(coalesce(sum(ST_length(geography(geometry)))/1000,0) as
NUMERIC),4)||'KM' field_value fr
