2 ms·
"Thanks, I updated the post... In Postgres, it behaves as a DELETE without a where clause..." I think there may still be some confusion. DELETE is an O(n) oper
by jeffdavis 13y ago
"Thanks, I updated the post... In Postgres, it behaves as a DELETE without a where clause..."
I think there may still be some confusion. DELETE is an O(n) operation that actually examines the tuples; TRUNCATE is an O(1) operation that doesn't look at any tuples.