Re: [HACKERS] WAL logging problem in 9.4.3?

From: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
To: andrew(dot)dunstan(at)2ndquadrant(dot)com
Cc: hlinnaka(at)iki(dot)fi, robertmhaas(at)gmail(dot)com, michael(at)paquier(dot)xyz, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] WAL logging problem in 9.4.3?
Date: 2018-11-14 03:47:36
Message-ID: 20181114.124736.206988673.horiguchi.kyotaro@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello.

At Thu, 11 Oct 2018 17:04:53 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> wrote in <20181011(dot)170453(dot)123148806(dot)horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
> At Thu, 11 Oct 2018 13:42:35 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> wrote in <20181011(dot)134235(dot)218062184(dot)horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
> I refactored getPendingSyncEntry out of RecordPendingSync,
> BufferNeedsWAL and RelationTruncate. And split the second patch
> into infrastracture-side and user-side ones. I expect it makes
> reviewing far easier.
>
> I reaplce RelationNeedsWAL in a part of code added in
> heap_update() by bfa2ab56bb.
>
> - v3-0001-TAP-test-for-copy-truncation-optimization.patch
>
> TAP test
>
> -v3-0002-Write-WAL-for-empty-nbtree-index-build.patch
>
> nbtree "fix"
>
> - v3-0003-Add-infrastructure-to-WAL-logging-skip-feature.patch
>
> Pending-sync infrastructure.
>
> - v3-0004-Fix-WAL-skipping-feature.patch
>
> Actual fix of WAL skipping feature.

0004 was shot by e9edc1ba0b. Rebased to the current HEAD.
Successfully built and passeed all regression/recovery tests
including additional recovery/t/016_wal_optimize.pl.

reagrds.

--
Kyotaro Horiguchi
NTT Open Source Software Center

Attachment Content-Type Size
v4-0004-Fix-WAL-skipping-feature.patch text/x-patch 16.7 KB
v4-0003-Add-infrastructure-to-WAL-logging-skip-feature.patch text/x-patch 22.6 KB
v4-0002-Write-WAL-for-empty-nbtree-index-build.patch text/x-patch 2.1 KB
v4-0001-TAP-test-for-copy-truncation-optimization.patch text/x-patch 7.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2018-11-14 04:16:02 Re: Speeding up INSERTs and UPDATEs to partitioned tables
Previous Message Denny Herssein 2018-11-14 03:20:12 Ltree Extension Enhancements