Re: Help understand why DELETE is so slow

2023-12-04 Thread Ping Yao
Hi Merlin, Thank you for the comment. I think we do. What I found odd here is the Query Plan (with analyze) clearly shows the actual execution to be very quick, that's why I don't think it's an index problem. What do you think? Ping -- Pook-Ping Yao (He/Him) Chief Technology

Help understand why DELETE is so slow

2023-12-01 Thread Ping Yao
lanning Time: 0.053 ms Execution Time: 328233.799 ms (20 rows) If I understand this correct, each step is quite quick, but for some reason, the total execution time still took >5mins. Thank you. Ping -- Pook-Ping Yao (He/Him) Chief Technology Officer and co-Founder Optigo Networks Inc