Hans-Juergen Schoenig: PostgreSQL: DELETE vs. TRUNCATE

Data isn’t only about storage and accumulation – sometimes it’s also about deletion, cleanup and archiving. In SQL there’s more than one way to empty a table. Two essential methods are...