How to delete 11M rows...
Wait forever..
Discussion
😳
Is auto-commit enabled? 😀
Yep… when I started to purge all the spam, I had so much it caused table locks and all sort of crap.
I ended up having to process it in batches. And now it works great.
rm -rf /var/lib/pgsql/ #yolo