Re: Adding primary key on table with 3 billion records.
Irene Yeh <[email protected]> Wed, 30 Oct 2019 08:56:33 -0700
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <[email protected]> |
Ok. Did my stop and restart completely restart the auto vacuum job? Irene > On Oct 30, 2019, at 01:03, Laurenz Albe <[email protected]> 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 >