DELETE vs TRUNCATE explanation - Mailing list pgsql-performance

From Craig Ringer
Subject DELETE vs TRUNCATE explanation
Date
Msg-id 4FFCCAC4.4030503@ringerc.id.au
Whole thread Raw
Responses Re: DELETE vs TRUNCATE explanation
List pgsql-performance
Hi

After seeing a few discussions here and on Stack Overflow I've put
together a quick explanation of why "DELETE FROM table;" may be faster
than "TRUNCATE table" for people doing unit testing on lots of tiny
tables, people who're doing this so often they care how long it takes.

I'd love it if a few folks who know the guts were to take a look and
verify its correctness:

http://stackoverflow.com/a/11423886/398670

--
Craig Ringer

pgsql-performance by date:

Previous
From: Reza Taheri
Date:
Subject: Re: The need for clustered indexes to boost TPC-V performance
Next
From: Daniel Farina
Date:
Subject: Re: DELETE vs TRUNCATE explanation