Re: WAL consistency check facility

From: Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Amit Kapila <amit(dot)kapila(at)enterprisedb(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Subject: Re: WAL consistency check facility
Date: 2016-08-25 16:41:01
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-hackers


I've added the feature in CP app. Following are the testing details:

1. In master, I've enabled following configurations:

* wal_level = replica
* max_wal_senders = 3
* wal_keep_segments = 4000
* hot_standby = on
* wal_consistency_mask = 511 /* Enable consistency check mask bit*/

2. In slave, I've enabled following configurations:

* standby_mode = on
* wal_consistency_mask = 511 /* Enable consistency check mask bit*/

3. Then, I performed gmake installcheck in master. I didn't get any
warning regarding WAL inconsistency in slave.

I've made following changes to the attached patch:

1. For BRIN pages, I've masked the unused space, PD_PAGE_FULL and
2. For Btree pages, I've masked BTP_HALF_DEAD, BTP_SPLIT_END,
3. For GIN_DELETED page, I've masked the entire page since the page is
always initialized during recovery.
4. For Speculative Heap tuple insert operation, there was
inconsistency in t_ctid value. So, I've modified the t_ctid value (in
backup page) to current block number and offset number. Need

What needs to be done:
1. Add support for other Resource Managers.
2. Modify masking techniques for existing Resource Managers (if required).
3. Modify the GUC parameter which will accept a list of rmgr names.
4. Modify the technique for identifying rmgr names for which the
feature should be enabled.
5. Generalize the page type identification technique.

On Wed, Aug 24, 2016 at 2:14 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On 22 August 2016 at 16:56, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>> On 22 August 2016 at 13:44, Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com> wrote:
>>> Please let me know your thoughts on this.
>> Do the regression tests pass with this option enabled?
> Hi,
> I'd like to be a reviewer on this. Please can you add this onto the CF
> app so we can track the review?
> Please supply details of the testing and test coverage.
> Thanks
> --
> Simon Riggs
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Thanks & Regards,
Kuntal Ghosh

Attachment Content-Type Size
walconsistency_v4.patch text/x-patch 29.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Claudio Freire 2016-08-25 16:55:58 Re: increasing the default WAL segment size
Previous Message Tom Lane 2016-08-25 15:43:51 Re: PG_DIAG_SEVERITY and a possible bug in pq_parse_errornotice()