From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts |
Date: | 2014-07-21 03:19:30 |
Message-ID: | 26504.1405912770@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I wrote:
> Here's a draft patch for this. I think this will fix all cases where
> the "1" minmxid inserted by previous pg_upgrade versions is actually
> in the future at the time we run VACUUM. We would still be at risk if
> it had been in the future when pg_upgrade ran but no longer is now,
> since that would mean there could be non-lock-only mxids on disk that
> are older than "1". However, for the reasons discussed upthread, it
> seems fairly unlikely to me that people would actually get burnt in
> practice, so I'm satisfied with doing this much and no more.
Ah, belay that: as coded, that would allow truncation of clog/multixact
as soon as any one relation in any one database had sane
frozenxid/minmxid. If we want to have any pretense of being safe, we have
to postpone truncation until *all* relations have been vacuumed. So more
like the attached, instead.
regards, tom lane
Attachment | Content-Type | Size |
---|---|---|
overwrite-nonsensical-frozenxid-or-minmxid-2.patch | text/x-diff | 12.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Burgess, Freddie | 2014-07-21 05:07:54 | PostgreSQL 9.3.4 Query Problems |
Previous Message | Tom Lane | 2014-07-21 00:52:44 | Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts |