| From: | Irene Yeh <ireney(at)fair(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Adding primary key on table with 3 billion records. |
| Date: | 2019-10-30 15:56:33 |
| Message-ID: | 2F3FD2F1-72EB-4BF6-9F26-686BC944A787@fair.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Ok. Did my stop and restart completely restart the auto vacuum job?
Irene
> On Oct 30, 2019, at 01:03, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2019-10-30 17:54:19 | Re: Adding primary key on table with 3 billion records. |
| Previous Message | Laurenz Albe | 2019-10-30 08:03:28 | Re: Adding primary key on table with 3 billion records. |