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 |
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 |