DELETE vs TRUNCATE explanation

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема DELETE vs TRUNCATE explanation
Дата
Msg-id 4FFCCAC4.4030503@ringerc.id.au
обсуждение исходный текст
Ответы Re: DELETE vs TRUNCATE explanation
Список 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 по дате отправления: