Re: storing an explicit nonce

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>

To: Neil Chen <carpenter.nail.cz@gmail.com>

Cc: Robert Haas <robertmhaas@gmail.com>, Stephen Frost <sfrost@snowman.net>, Andres Freund <andres@anarazel.de>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Masahiko Sawada <sawada.mshk@gmail.com>, Tom Kincaid <tomjohnkincaid@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>, Thomas Munro <thomas.munro@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Masahiko Sawada <masahiko.sawada@2ndquadrant.com>

Date: 2021-05-27T15:12:17Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Rethink method for assigning OIDs to the template0 and postgres DBs.
- 2cb1272445d2 15.0 landed
pg_upgrade: Preserve database OIDs.
- aa01051418f1 15.0 landed
pg_upgrade: Preserve relfilenodes and tablespace OIDs.
- 9a974cbcba00 15.0 landed
Fix for new Boolean node
- cf925936ecc0 15.0 cited
Improve error handling of HMAC computations
- 5513dc6a304d 15.0 cited
Add macro RelationIsPermanent() to report relation permanence
- 95d77149c535 14.0 landed
Enhance nbtree index tuple deletion.
- d168b666823b 14.0 cited

On Thu, May 27, 2021 at 05:45:21PM +0800, Neil Chen wrote:
> Greetings,
> 
> On Thu, May 27, 2021 at 4:52 PM Bruce Momjian <bruce@momjian.us> 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
>     > something.
>     >
>     > Why can't checksums also throw away hint bit changes like you want to do
>     > for file encryption and not require wal_log_hints?
> 
> 
> 
> I'm really confused about it, too. I read the above communication, not sure if
> my understanding is correct... What we are facing is not only the change of
> flag such as *pd_flags*, but also others like pointer array changes in btree
> like Robert said. We don't need them to write a WAL record.

Well, the code now does write full page images for hint bit changes, so
it should work fine.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.