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 7bf3c1bb7f4332a1596bcf1084b87152f0b00166.camel@cybertec.at
Whole thread Raw
In response to Re: Adding primary key on table with 3 billion records.  (Irene Yeh <ireney@fair.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Irene Yeh
Date:
Subject: Re: Adding primary key on table with 3 billion records.
Next
From: Andreas Kretschmer
Date:
Subject: Re: transaction wraparound