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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Irene Yeh <ireney(at)fair(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Adding primary key on table with 3 billion records.
Date: 2019-10-30 08:03:28
Message-ID: b6efd476a1d7f59c9e0bd945fb5e04ec6ff26a84.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Irene Yeh 2019-10-30 15:56:33 Re: Adding primary key on table with 3 billion records.
Previous Message Irene Yeh 2019-10-30 04:17:20 Adding primary key on table with 3 billion records.