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>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Adding primary key on table with 3 billion records.
Date: 2019-10-30 17:54:19
Message-ID: 7bf3c1bb7f4332a1596bcf1084b87152f0b00166.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Irene Yeh wrote:
> Ok. Did my stop and restart completely restart the auto vacuum job?

Yes. Every interruption will further delay it.

You should reduce "autovacuum_vacuum_cost_delay" to at most 2ms and
raise "maintenance_work_mem", both will speed up autovacuum.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Павел Ерёмин 2019-10-31 07:15:45 transaction wraparound
Previous Message Irene Yeh 2019-10-30 15:56:33 Re: Adding primary key on table with 3 billion records.