gpdb
gpdb copied to clipboard
use plpython3u write gp7 will lock
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,
select query,* from pg_stat_activity where state='active'
the copy sql is locked, why?
Greenplum version or build
7.1
OS version and uname -a
centos8