Re: psql: \dl+ to list large objects privileges

2021-09-17 Thread Neil Chen
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: tested, passed Documentation:tested, passed Hi, I think this is an interesting patch. +1 I tested it for

Re: Automatic notification of top transaction IDs

2021-07-27 Thread Neil Chen
Greetings, I simply tested it and it works well. But I got a compilation warning, should we move the definition of function FullTransactionIdToStr to the "transam.h"? -- There is no royal road to learning. HighGo Software Co.

Re: storing an explicit nonce

2021-05-28 Thread Neil Chen
On Fri, May 28, 2021 at 2:12 PM Neil Chen wrote: > > When the checksums are disabled, we can use these unused checksum values > as a counter to make sure we have different nonce even if we don't write > the new WAL record. > > Ah, well, I think I've figured it out for mysel

Re: storing an explicit nonce

2021-05-28 Thread Neil Chen
On Thu, May 27, 2021 at 11:12 PM Bruce Momjian wrote: > > Well, the code now does write full page images for hint bit changes, so > it should work fine. > > Yes, indeed it works well and I'd tested it. But here I want to make clear my understanding of the argument, if there is any problem please

Re: storing an explicit nonce

2021-05-27 Thread Neil Chen
Greetings, On Thu, May 27, 2021 at 4:52 PM Bruce Momjian wrote: > > > > I am confused why checksums, which are widely used, acceptably require > > wal_log_hints, but there is concern that file encryption, which is > > heavier, cannot acceptably require wal_log_hints. I must be missing > >

Re: [PATCH] In psql \?, add [+] annotation where appropriate

2021-05-25 Thread Neil Chen
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: tested, passed Documentation:tested, passed Hi, thank you for your work. I think this is a meaningful

Re: Key management with tests

2021-04-06 Thread Neil Chen
Hi Bruce, I went through these patches and executed the test script you added for the KMS section, which looks all good. This is a point that looks like a bug - in patch 10, you changed the location and use of *RelFileNodeSkippingWAL()*, but the modified code logic seems different from the

Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails

2021-03-03 Thread Neil Chen
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation:tested, passed Greetings, I learned about the patch and read your discussions.

Re: Phrase search vs. multi-lexeme tokens

2021-01-25 Thread Neil Chen
Hi Alexander, On Mon, Jan 25, 2021 at 11:25 PM Alexander Korotkov wrote: > > BTW, you mentioned you read the documentation. Do you think it needs > to be adjusted accordingly to the patch? > > Yes, I checked section 8.11, section 9.13 and Chapter 12 of the document. The change of this patch did

Re: Phrase search vs. multi-lexeme tokens

2021-01-25 Thread Neil Chen
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation:not tested Greetings, Although I am not an expert in this field, I carefully

Re: Key management with tests

2021-01-12 Thread Neil Chen
Thank you for your reply, On Wed, Jan 13, 2021 at 12:08 AM Stephen Frost wrote: > > No, we can't 'modify the page format as we wish'- if we change away from > using a C structure then we're going to be modifying quite a bit of > code which otherwise doesn't need to be changed. The proposed

Re: Key management with tests

2021-01-11 Thread Neil Chen
Hi Stephen, On Tue, Jan 12, 2021 at 10:47 AM Stephen Frost wrote: > > This is an interesting question but ultimately I don't think we should > be looking at this from the perspective of allowing arbitrary changes to > the page format. The challenge is that much of the page format, today, > is

Re: Proposed patch for key management

2021-01-04 Thread Neil Chen
On Tue, Jan 5, 2021 at 10:18 AM Bruce Momjian wrote: > On Fri, Jan 1, 2021 at 06:26:36PM +, Alastair Turner wrote: > > There is all sorts of flexibility being proposed: > > * scope of keys > * encryption method > * encryption mode > * internal/external > > Some of this is related to

Re: Proposed patch for key managment

2020-12-17 Thread Neil Chen
On Fri, Dec 18, 2020 at 3:02 AM Bruce Momjian wrote: > > Here is a run of all four authentication methods, and updated scripts. > I have renamed Yubiki to PIV since the script should work with anY > PIV-enabled deviced, like a CAC. > > Thanks for attaching these patches. The unfortunate thing is

Re: Proposed patch for key managment

2020-12-14 Thread Neil Chen
Hi, Bruce I read your question and here are some of my thoughts. Why is KmgrShmemData a struct, when it only has a single member? > Are > all shared memory areas structs? > Yes, all areas created by ShmemInitStruct() are structs. I think the significance of using struct is that

Re: Proposed patch for key managment

2020-12-10 Thread Neil Chen
Hi, everyone > > I have read the patch and did some simple tests. I'm not entirely sure > about some code segments; e.g.: > > In the BootStrapKmgr() we generate a data encryption key by: > key = generate_crypto_key(file_encryption_keylen); > > However, I found that the file_encryption_keylen is

Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted

2020-11-19 Thread Neil Chen
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation:not tested Hi, I have tested the feature and it worked well. One thing that