Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding primary key on table with 3 billion records. - Mailing list pgsql-novice

From Irene Yeh
Subject Re: Adding primary key on table with 3 billion records.
Date
Msg-id 2F3FD2F1-72EB-4BF6-9F26-686BC944A787@fair.com
Whole thread Raw
In response to Re: Adding primary key on table with 3 billion records.  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Adding primary key on table with 3 billion records.
List pgsql-novice
Tree view 
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
>

pgsql-novice by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Adding primary key on table with 3 billion records.
Next
From: Laurenz Albe
Date:
Subject: Re: Adding primary key on table with 3 billion records.