Vacuuming

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

Responses

Browse pgsql-general by date

  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?