Re: [GENERAL] Vacuum and inserts

Thanks to everyone for your comments. It does sound like my understanding was basically correct, but also that autovacuum is still worthwhile in my situation, for reasons other than concurrency. ///ark

[GENERAL] Vacuum and inserts

My coworker and I are having an argument about whether it's necessary to VACUUM an insert-only table. My theory is that since there are no outdated nor deleted rows, VACUUM doesn't do anything. I just loaded a TRUNCATEd table with no indexes with 4 million records, indexed it, then ran VACUUM. The