RE: [Patch] Optimize dropping of relation buffers using dlist

From: "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>
To: "k(dot)jamison(at)fujitsu(dot)com" <k(dot)jamison(at)fujitsu(dot)com>, 'Amit Kapila' <amit(dot)kapila16(at)gmail(dot)com>
Cc: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, "tgl(at)sss(dot)pgh(dot)pa(dot)us" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "andres(at)anarazel(dot)de" <andres(at)anarazel(dot)de>, "robertmhaas(at)gmail(dot)com" <robertmhaas(at)gmail(dot)com>, "tomas(dot)vondra(at)2ndquadrant(dot)com" <tomas(dot)vondra(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: [Patch] Optimize dropping of relation buffers using dlist
Date: 2020-10-08 06:37:39
Message-ID: OSBPR01MB2982D4686A10E356509750BDFE0B0@OSBPR01MB2982.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Kirk san,

(1)
+ * This returns an InvalidBlockNumber when smgr_cached_nblocks is not
+ * available and when not in recovery path.

+ /*
+ * We cannot believe the result from smgr_nblocks is always accurate
+ * because lseek of buggy Linux kernels doesn't account for a recent
+ * write.
+ */
+ if (!InRecovery && result == InvalidBlockNumber)
+ return InvalidBlockNumber;
+

These are unnecessary, because mdnblocks() never returns InvalidBlockNumber and conseuently smgrnblocks() doesn't return InvalidBlockNumber.

(2)
+smgrnblocks(SMgrRelation reln, ForkNumber forknum, bool *isCached)

I think it's better to make the argument name iscached so that camel case aligns with forknum, which is not forkNum.

(3)
+ * This is caused by buggy Linux kernels that might not have accounted
+ * the recent write. If a fork's nblocks is invalid, exit loop.

"accounted for" is the right English?
I think The second sentence should be described in terms of its meaning, not the program logic. For example, something like "Give up the optimization if the block count of any fork cannot be trusted."
Likewise, express the following part in semantics.

+ * Do explicit hashtable lookup if the total of nblocks of relation's forks
+ * is not invalid and the nblocks to be invalidated is less than the

(4)
+ if (nForkBlocks[i] == InvalidBlockNumber)
+ {
+ nTotalBlocks = InvalidBlockNumber;
+ break;
+ }

Use isCached in if condition because smgrnblocks() doesn't return InvalidBlockNumber.

(5)
+ nBlocksToInvalidate = nTotalBlocks - firstDelBlock[i];

should be

+ nBlocksToInvalidate += (nForkBlocks[i] - firstDelBlock[i]);

(6)
+ bufHdr->tag.blockNum >= firstDelBlock[j])
+ InvalidateBuffer(bufHdr); /* releases spinlock */

The right side of >= should be cur_block.


Regards
Takayuki Tsunakawa

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2020-10-08 06:48:23 Re: speed up unicode normalization quick check
Previous Message Daniel Westermann (DWE) 2020-10-08 06:34:32 Wrong example in the bloom documentation