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

Ok. Did my stop and restart completely restart the auto vacuum job?

Irene

> On Oct 30, 2019, at 01:03, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> 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
>