Neki, sharded Postgres, is now available. Learn more
Sign in
Get in touch
Navigation

Posts by Tom Pang

I don't trust ON DELETE CASCADE

[Engineering, PostgreSQL]

Tom Pang

A one-line convenience in your database schema can become an outage. There are better ways to delete data that won't risk locking up your database. →

The only scalable delete in Postgres is DROP TABLE

[Engineering, PostgreSQL]

Tom Pang

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