Kieran @Kieran - 2y
How to delete 11M rows... Wait forever..
75f45 - 2y
😳
facda - 2y
Is auto-commit enabled? 😀
b2dd4 - 2y
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.
Does IST mean anything other than Indian Standard Time too? Didn't realize there were two ISTs
Irish Standard Time
🤯
c9144 - 2y
Israeli Standard Time?
30da3 - 2y
delete from events where id in (select id from events where kind = 7 limit 100000)
jespada @jespada - 2y
rm -rf /var/lib/pgsql/ #yolo
