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

On Tue, 2019-10-29 at 21:17 -0700, Irene Yeh wrote:
> Here are some issues we're having right now 
> 1. The DB started autovacuum after we created a unique index. It's been running
> for a really really long time and it won't let us alter the table to add null constraint.
> I tried to cancel the autovacuum job but it just starts backup.

If it blocks ALTER TABLE, it must be an anti-wraparound autovacuum.

Let it finish before you continue.  Once this necessary maintenance job
is done, you will be able to proceed.

Yours,
Laurenz Albe
-- 
+43-670-6056265
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Web: https://www.cybertec-postgresql.com