| From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Kevin Grittner <kgrittn(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: fixing old_snapshot_threshold's time->xid mapping |
| Date: | 2020-10-06 05:32:57 |
| Message-ID: | CA+hUKGJyw=uJ4eL1x=+vKm16fLaxNPvKUYtnChnRkSKi024u_A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Sep 25, 2020 at 2:00 PM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
> On Thu, Sep 24, 2020 at 03:46:14PM -0400, Robert Haas wrote:
> > Committed.
>
> Cool, thanks.
+1
> > Thomas, with respect to your part of this patch set, I wonder if we
> > can make the functions that you're using to write tests safe enough
> > that we could add them to contrib/old_snapshot and let users run them
> > if they want. As you have them, they are hedged around with vague and
> > scary warnings, but is that really justified? And if so, can it be
> > fixed? It would be nicer not to end up with two loadable modules here,
> > and maybe the right sorts of functions could even have some practical
> > use.
Yeah, you may be right. I am thinking about that. In the meantime,
here is a rebase. A quick recap of these remaining patches:
0001 replaces the current "magic test mode" that didn't really test
anything with a new test mode that verifies pruning and STO behaviour.
0002 fixes a separate bug that Andres reported: the STO XID map
suffers from wraparound-itis.
0003 adds a simple smoke test for Robert's commit 55b7e2f4. Before
that fix landed, it failed.
> I have switched this item as waiting on author in the CF app then, as
> we are not completely done yet.
Thanks. For the record, I think there is still one more complaint
from Andres that remains unaddressed even once these are in the tree:
there are thought to be some more places that lack
TestForOldSnapshot() calls.
| Attachment | Content-Type | Size |
|---|---|---|
| v10-0001-Rewrite-the-snapshot_too_old-tests.patch | text/x-patch | 28.3 KB |
| v10-0002-Truncate-snapshot-too-old-time-map-when-CLOG-is-.patch | text/x-patch | 6.9 KB |
| v10-0003-Add-TAP-test-for-snapshot-too-old-time-map-maint.patch | text/x-patch | 2.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2020-10-06 05:34:58 | Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? |
| Previous Message | Dilip Kumar | 2020-10-06 05:30:55 | Re: [HACKERS] Custom compression methods |