From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Brian Ghidinelli <brian(at)vfive(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid` |
Date: | 2016-04-04 20:46:19 |
Message-ID: | 20160404204619.GA223482@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Brian Ghidinelli wrote:
> Thanks for the follow up Alvaro. I’m no longer on the bugs list so
> don’t know if this will make it through, but I went the route of
> recreating the table and updating all of the foreign key references
> and shared that on Feb 19th.
>
> This seems to have fixed the problem with vacuuming the table however
> it did not update the multixact value which still reads 1. Any idea if
> this will still cause problems in the future?
Well, your use of multixacts appear low so it's normal that it hasn't
moved forward. That counter is normally only moved forward as vacuum
tries to clean up multixacts that are 5 million old. Yours are only
~84000 old, so you have a long way to go before the counter is updated.
Your system should be fine.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-04-04 21:40:43 | Re: BUG #14063: ALTER SYSTEM accepts 'newline' and renders itself inoperable. |
Previous Message | cpacejo | 2016-04-04 20:33:04 | BUG #14064: Sort order of bytea, etc. not defined |