Re: [PERFORM] need vacuum after insert/truncate/insert?

2006-07-07 Thread Markus Schaber
Hi, Craig, Craig A. James wrote: > If I insert a bunch of rows, then truncate, then insert a bunch more > rows, do I need to vacuum? I've been assuming that TRUNCATE TABLE is a > brute-force technique that more-or-less tosses the old table and starts > fresh so that no vacuum is necessary. > > S

[PERFORM] need vacuum after insert/truncate/insert?

2006-07-06 Thread Craig A. James
If I insert a bunch of rows, then truncate, then insert a bunch more rows, do I need to vacuum? I've been assuming that TRUNCATE TABLE is a brute-force technique that more-or-less tosses the old table and starts fresh so that no vacuum is necessary. Second question: Same scenario as above, bu