From: | Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Vacuuming |
Date: | 2007-05-08 01:42:52 |
Message-ID: | 463FD59C.1060509@autoledgers.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-05-08 02:27:29 | Re: Vacuuming |
Previous Message | Richard P. Welty | 2007-05-08 00:33:56 | Re: Anyone know a good opensource CRM that actually installs with Posgtres? |