Re: ERROR: found multixact from before relminmxid

Quick correction :)

I am running PostgreSQL *9.6.8* on AWS RDS. I'm going to try to pg-repack
the table and will look to upgrade to *9.6.9* (though it's not presently
available on RDS).

Sean

On Fri, Jul 13, 2018 at 11:14 AM Sean McIntyre <
sean(dot)mcintyre(at)warbyparker(dot)com> wrote:

> Dear all,
>
> I just wanted to report that I found similar error "found multixact from
> before relminmxid" that Alexandre Arruda and Jeremy Finzel recently
> reported and discussed with Andres Freund. (Thanks all for good notes.)
>
> I get this error when vacuuming a specific table in my high-transaction
> OLTP workload database. I am running PostgreSQL 9.5.8 on AWS RDS. I'm going
> to try to pg-repack the table and will look to upgrade to 9.5.9 (though
> it's not presently available).
>
> Best,
>
> Sean
>
> --
>
> Sean McIntyre
> WARBY PARKER
> <https://www.warbyparker.com/?utm_source=employee&utm_medium=email&utm_content=signature&utm_campaign=signature&cvosrc=email.employee.signature>
>
> Summer reading calls for summery frames
> <https://www.warbyparker.com/summer-2018?utm_source=signature&utm_medium=email&utm_campaign=Summer-2018&cvosrc=email.signature.summer-2018>
> We made an app! Download it here
> <https://itunes.apple.com/app/apple-store/id1107693363?pt=1427163&ct=Employee%20Email%20Signature&mt=8>
> Follow us: Facebook
> <http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fwarbyparker&sa=D&sntz=1&usg=AFrqEzfUEaV6C9BaTQ8cI-VKdanu2UUQbw>
> , Twitter
> <http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fwarbyparker&sa=D&sntz=1&usg=AFrqEzczMD6HXAtHLBzviQV_EtD3ckoJVQ>
> , Instagram <http://instagram.com/warbyparker>, Snapchat
> <https://www.snapchat.com/add/warbyparker>
>

--

Sean McIntyre
WARBY PARKER
<https://www.warbyparker.com/?utm_source=employee&utm_medium=email&utm_content=signature&utm_campaign=signature&cvosrc=email.employee.signature>

Summer reading calls for summery frames
<https://www.warbyparker.com/summer-2018?utm_source=signature&utm_medium=email&utm_campaign=Summer-2018&cvosrc=email.signature.summer-2018>
We made an app! Download it here
<https://itunes.apple.com/app/apple-store/id1107693363?pt=1427163&ct=Employee%20Email%20Signature&mt=8>
Follow us: Facebook
<http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fwarbyparker&sa=D&sntz=1&usg=AFrqEzfUEaV6C9BaTQ8cI-VKdanu2UUQbw>
, Twitter
<http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fwarbyparker&sa=D&sntz=1&usg=AFrqEzczMD6HXAtHLBzviQV_EtD3ckoJVQ>
, Instagram <http://instagram.com/warbyparker>, Snapchat
<https://www.snapchat.com/add/warbyparker>