gpdb icon indicating copy to clipboard operation
gpdb copied to clipboard

use plpython3u write gp7 will lock

Open wonb168 opened this issue 1 year ago • 9 comments
trafficstars

Bug Report

I used plpython3u to using duckdb, duckdb read gp is quickly, but write back to gp:

sql=f"""
insert into gp.adm.kpi_summary_duck
select * from tmp_rst
;"""
duckdb.execute(sql)

this run in python3.9 about 2 min, but in plpython(the same py3.9), even 36min not finished, image

select query,* from pg_stat_activity where state='active'

the copy sql is locked, why? image

Greenplum version or build

7.1

OS version and uname -a

centos8

wonb168 avatar Apr 08 '24 08:04 wonb168