Re: Adding primary key on table with 3 billion records.

Irene Yeh wrote:
> Ok. Did my stop and restart completely restart the auto vacuum job?

Yes.  Every interruption will further delay it.

You should reduce "autovacuum_vacuum_cost_delay" to at most 2ms and
raise "maintenance_work_mem", both will speed up autovacuum.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com