| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_multixact not getting truncated |
| Date: | 2014-11-20 21:47:29 |
| Message-ID: | 27662.1416520049@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Josh Berkus <josh(at)agliodbs(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2014-11-20 21:52:14 | Re: superuser() shortcuts |
| Previous Message | David G Johnston | 2014-11-20 21:46:23 | Re: Doing better at HINTing an appropriate column within errorMissingColumn() |