Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: Adding primary key on table with 3 billion records.
Date
Msg-id b6efd476a1d7f59c9e0bd945fb5e04ec6ff26a84.camel@cybertec.at
Whole thread Raw
In response to Adding primary key on table with 3 billion records.  (Irene Yeh <ireney@fair.com>)
Responses Re: Adding primary key on table with 3 billion records.
List pgsql-novice
Tree view 
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: Irene Yeh
Date:
Subject: Adding primary key on table with 3 billion records.
Next
From: Irene Yeh
Date:
Subject: Re: Adding primary key on table with 3 billion records.