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

google.com/goto: Google's anti-scraping update
1e1a · Hacker News · 19h ago
Will There Be a 7G?
Betelbuddy · Hacker News · 5h ago
Navier-Stokes Announcement
rvz · Hacker News · 18h ago
Measuring the sloppiness of code
doppp · Hacker News · 1d ago
Google will buy half the electricity from one of Finland's nuclear power plants
lukaspetersson · Hacker News · 1d ago