On 07/12/2012 02:10 AM, Matthew Woodcraft wrote:
I think a documentation change would be worthwhile. At the moment the TRUNCATE page says, with no caveats, that it is faster than unqualified DELETE.
+1 to updating the docs to reflect the fact that TRUNCATE may have a higher fixed cost than DELETE FROM table; but also prevents bloat.
It's a weird little corner case, but with database-backed unit testing it's going to become a more significant one whether or not it feels like it makes any sense.
-- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
