need vacuum after insert/truncate/insert?

Поиск
Список
Период
Сортировка
От Craig A. James
Тема need vacuum after insert/truncate/insert?
Дата
Msg-id 44ADBDB8.5010008@modgraph-usa.com
обсуждение исходный текст
Ответ на Query plan issue when upgrading to postgres 8.14 (from postgres 8.12 or 7.4)  (Ioana Danes <ioanasoftware@yahoo.ca>)
Ответы Re: need vacuum after insert/truncate/insert?  (Markus Schaber <schabi@logix-tt.com>)
Список pgsql-performance
If I insert a bunch of rows, then truncate, then insert a bunch more rows, do I need to vacuum?  I've been assuming
thatTRUNCATE TABLE is a brute-force technique that more-or-less tosses the old table and starts fresh so that no vacuum
isnecessary. 

Second question: Same scenario as above, but now the table has indexes.  Is a reindex needed, or are the indexes they
"truncated"too? 

Thanks,
Craig


В списке pgsql-performance по дате отправления:

Предыдущее
От: Chris
Дата:
Сообщение: Re: Query plan issue when upgrading to postgres 8.14 (from
Следующее
От: Michael Loftis
Дата:
Сообщение: Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL