DELETE vs TRUNCATE explanation

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

Предыдущее
От: Reza Taheri
Дата:
Сообщение: Re: The need for clustered indexes to boost TPC-V performance
Следующее
От: Daniel Farina
Дата:
Сообщение: Re: DELETE vs TRUNCATE explanation