Re: pg_multixact not getting truncated - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_multixact not getting truncated
Date
Msg-id 27662.1416520049@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_multixact not getting truncated  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> Well, the first thing that comes to mind is that template0 should be
> "permanently frozen".  That is, all objects in it should be created with
> frozen xid and mxids.  After all, nobody can modify anything in it.

That sounds about as unsafe as can be.  You can't stop superusers from
connecting to template0 and modifying it if they want to ... and I don't
really want to say "ok, the consequence of that is silent disaster many
moons later".
        regards, tom lane



pgsql-hackers by date:

Previous
From: David G Johnston
Date:
Subject: Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Next
From: Peter Eisentraut
Date:
Subject: Re: superuser() shortcuts