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

Anthropic S-1
SiNTEx · Hacker News · 1d ago
Police are using AI to pull over drivers for 'suspicious' behavior
gumby · Hacker News · 7h ago
Python's experimental JIT to be removed
f311a · Hacker News · 12h ago
Solar power is becoming bigger than nuclear
geox · Hacker News · 1d ago
The Exponential Time Hypothesis Is False [pdf]
vok · Hacker News · 1d ago