From: | Noah Misch <noah(at)leadboat(dot)com> |
---|---|
To: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
Cc: | robertmhaas(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org, 9erthalion6(at)gmail(dot)com, andrew(dot)dunstan(at)2ndquadrant(dot)com, hlinnaka(at)iki(dot)fi, michael(at)paquier(dot)xyz |
Subject: | Re: [HACKERS] WAL logging problem in 9.4.3? |
Date: | 2020-03-01 19:56:32 |
Message-ID: | 20200301195632.GA135286@rfd.leadboat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Feb 27, 2020 at 04:00:24PM +0900, Kyotaro Horiguchi wrote:
> At Tue, 25 Feb 2020 21:36:12 -0800, Noah Misch <noah(at)leadboat(dot)com> wrote in
> > On Tue, Feb 25, 2020 at 10:01:51AM +0900, Kyotaro Horiguchi wrote:
> > > At Sat, 22 Feb 2020 21:12:20 -0800, Noah Misch <noah(at)leadboat(dot)com> wrote in
> > > > On Fri, Feb 21, 2020 at 04:49:59PM +0900, Kyotaro Horiguchi wrote:
> > > If we decide to keep the consistency there, I would like to describe
> > > the code is there for consistency, not for the benefit of a specific
> > > assertion.
> > >
> > > (cluster.c:1116)
> > > - * new. The next step for rel2 is deletion, but copy rd_*Subid for the
> > > - * benefit of AssertPendingSyncs_RelationCache().
> > > + * new. The next step for rel2 is deletion, but copy rd_*Subid for the
> > > + * consistency of the fieles. It is checked later by
> > > + * AssertPendingSyncs_RelationCache().
> >
> > I think the word "consistency" is too vague for "consistency of the fields" to
> > convey information. May I just remove the last sentence of the comment
> > (everything after "* new.")?
>
> I'm fine with that:)
>
> > > I agree that relation works as the generic name of table-like
> > > objects. Addition to that, doesn't using the word "storage file" make
> > > it more clearly? I'm not confident on the wording itself, but it will
> > > look like the following.
> >
> > The docs rarely use "storage file" or "on-disk file" as terms. I hesitate to
> > put more emphasis on files, because they are part of the implementation, not
> > part of the user interface. The term "rewrites"/"rewriting" has the same
> > problem, though. Yet another alternative would be to talk about operations
> > that change the pg_relation_filenode() return value:
> >
> > In <literal>minimal</literal> level, no information is logged for permanent
> > relations for the remainder of a transaction that creates them or changes
> > what <function>pg_relation_filenode</function> returns for them.
> >
> > What do you think?
>
> It sounds somewhat obscure.
I see. I won't use that.
> Coulnd't we enumetate examples? And if we
> could use pg_relation_filenode, I think we can use just
> "filenode". (Thuogh the word is used in the documentation, it is not
> defined anywhere..)
func.sgml does define the term. Nonetheless, I'm not using it.
> ====
> In <literal>minimal</literal> level, no information is logged for
> permanent relations for the remainder of a transaction that creates
> them or changes their <code>filenode</code>. For example, CREATE
> TABLE, CLUSTER or REFRESH MATERIALIZED VIEW are the command of that
> category.
> ====
>
> # sorry for bothering you..
Including examples is fine. Attached v36nm has just comment and doc changes.
Would you translate this into back-patch versions for v9.5 through v12?
Attachment | Content-Type | Size |
---|---|---|
createsubid-cosmetics-v35nm.patch | text/plain | 2.4 KB |
toast_get_valid_index-lock-v35nm.patch | text/plain | 1.9 KB |
log_newpage_range-args-v35nm.patch | text/plain | 1.7 KB |
skip-wal-v36nm.patch | text/plain | 115.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Floris Van Nee | 2020-03-01 20:15:25 | RE: Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare() |
Previous Message | Dean Rasheed | 2020-03-01 19:47:29 | Re: Some improvements to numeric sqrt() and ln() |