在针对一个不大的表格执行清空操作时，遇到了长时间执行且未返回结果的情况。网上搜索后，发现是遇到了死锁问题。
1. 可以在master节点，查询各进程并判断有可能是死锁的进程：
select gp_execution_dbid(), pid, relation::regclass, locktype, mode, granted
from gp_dist_random('pg_locks');
2. 查看具体什么语句持有的锁
select gp_execution_dbid() dbid,procpid,current_query
from gp_dist_random('pg_stat_activity')
where procpid in
(select pid from gp_dist_random('pg_locks') where locktype='relation' and mode='ExclusiveLock');
3.处理持有锁的pid
select pg_terminate_backend('procpid');
来自
buy cheap enclomiphene price in canada
generic enclomiphene canadian no prescription
commander kamagra sans ordonnance
acheter générique kamagra canada
discount androxal buy dublin
androxal delivered cod fedex
cheap dutasteride canada mail order
buying dutasteride without recipe
buying flexeril cyclobenzaprine purchase to canada
purchase flexeril cyclobenzaprine generic free shipping
buy gabapentin generic from canadian pharmacy
discount gabapentin generic india
canadian pharmacy fildena
buying fildena generic equivalent buy
online pharmacy usa itraconazole
purchase itraconazole buy safely online
ordering staxyn purchase online from canada
order staxyn generic efficacy
US pharmacies for avodart without rx
discount avodart generic europe
buy cheap xifaxan price prescription
buy xifaxan generic pharmacy canada
buy rifaximin generic is good
how to buy rifaximin purchase from canada
kamagra bez pﾅ册dpovﾄ嫖i
získejte zdarma vzorky kamagra online
回复 get avodart buy for cheap 取消回复