The only scalable delete in Postgres is DROP TABLE

·Hacker News··

Large DELETEs add work instead of reclaiming it. Structure your database so deletion becomes DROP TABLE or TRUNCATE.

Read full article →

Related Articles

Noise infusion banned from statistical products published by Census Bureau
nl · Hacker News · 1d ago
A 'cold blob' in the Atlantic could be a sign of AMOC shutdown – CNN
tambourine_man · Hacker News · 2h ago
The redistribution of housing wealth caused by rent control [pdf]
luu · Hacker News · 13h ago
New pancreatic cancer drug might open the door to much longer survival times
andsoitis · Hacker News · 1d ago
Arch Linux Now Believes Malware Incident Under Control: More Than 1,500 Packages
qwertox · Hacker News · 1d ago