Re: Multixact members limit exceeded

From: Peter Hunčár <hunci(at)hunci(dot)sk>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multixact members limit exceeded
Date: 2017-08-24 20:22:39
Message-ID: CADOjABkysqHFbaPK=F6q5L2bhKjsKpwXw7+f08V1y5LurNg_iA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

it took 10 days to autovacuum the 32TB toast table and after restarting
with previous (but slightly tuned autovacuum) parameters, the database
works just fine.
The data import is almost done, there are just several hundred thousands of
rows to add :)

The next headache will the the backup of those 110TB ;)

Thanks a lot for the help!

Peter

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-08-24 22:57:50 Re: Retrieving query results
Previous Message Tom Lane 2017-08-24 19:07:08 Re: creating tables in tablespace