Re: pg_multixact not getting truncated

<div dir="ltr"><p dir="ltr"><br /> On Thu, Nov 20, 2014 at 9:21 PM, Josh Berkus <<a href="mailto:josh@agliodbs.com"
target="_blank">josh@agliodbs.com</a>>wrote:<br /> > Well, the first thing that comes to mind is that template0
shouldbe<br /> > "permanently frozen". That is, all objects in it should be created with<br /> > frozen xid and
mxids.After all, nobody can modify anything in it.<p dir="ltr">This is actually the way it used to be. It was changed
becauseit was discovered there was some case where an unfrozen xid would end up in template0 anyways and for some
reasonit was hard to be sure to avoid it. I don't recall exactly what the situation was that triggered it but the
argumentwas made then that it was safest to just include template0 in autovacuum rather than depend on getting this
100%right and risk corruption.<p dir="ltr">--<br /> greg</div>