Is there any point to vacuuming a table if it has been bulk-populated by
data after a truncate?
I.e. If I do this:
TRUNCATE TABLE vehicles;
INSERT INTO vehicles (SELECT DISTINCT ON (dealer_id,vehicle_address) *
FROM vehicles_temp_load WHERE (dealer_id,vehicle_address) is not null);
Is there any point in vacuuming?
Also, is there any point in recreating indexes on this table after a
load like this or will indexes have been correctly maintained/updated by
the above insert. Note: This insert often loads tens of millions of records.
BTW, this is on Windows.
Thanks,
Paul.
--
Paul Lambert
Database Administrator
AutoLedgers