Horton

Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits

Anastasia Lubennikova <lubennikovaav@gmail.com>

View thread View on postgr.es
From: Anastasia Lubennikova <lubennikovaav@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Cc: Pavan Deolasee <pavan.deolasee@gmail.com>, Ibrar Ahmed <ibrar.ahmad@gmail.com>
Date: 2020-10-27T19:16:11Z
Lists: pgsql-hackers 
Status update for a commitfest entry.

This patch is ReadyForCommitter. It applies and passes the CI. There are no unanswered questions in the discussion. 

The discussion started in 2015 with a patch by Jeff Janes. Later it was revived by Pavan Deolasee.  After it was picked up by Ibrar Ahmed and finally, it was rewritten by me, so I moved myself from reviewers to authors as well.

The latest version was reviewed and tested by Ibrar Ahmed. The patch doesn't affect COPY FREEZE performance and significantly decreases the time of the following VACUUM.

Commits

  1. Fix COPY FREEZE with CLOBBER_CACHE_ALWAYS

  2. Set PD_ALL_VISIBLE and visibility map bits in COPY FREEZE

  3. docs: client certificates are always sent to the server

  4. Mark commit and abort WAL records with XLR_SPECIAL_REL_UPDATE.

  5. docs: land height is "elevation", not "altitude"

  6. Improve the internal implementation of ereport().