Re: Improving replay of XLOG_BTREE_VACUUM records - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Improving replay of XLOG_BTREE_VACUUM records
Date
Msg-id CANP8+j+Hh8us6P+KT9u4UB5cFTOJg2xBnCLekrOy7upqd7sE4w@mail.gmail.com
Whole thread Raw
In response to Re: Improving replay of XLOG_BTREE_VACUUM records  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Improving replay of XLOG_BTREE_VACUUM records
Re: Improving replay of XLOG_BTREE_VACUUM records
List pgsql-hackers
On 10 March 2016 at 09:22, Michael Paquier <michael.paquier@gmail.com> wrote:
On Thu, Mar 10, 2016 at 10:00 AM, Vladimir Borodin <root@simply.name> wrote:
> Let’s do immediately after you will send a new version of your patch? Or
> even better after testing your patch? Don’t get me wrong, but rejecting my
> patch without tangible work on your patch may lead to forgiving about the
> problem before 9.6 freeze.

This makes sense. Let's not reject this patch yet if the alternative
approach is not committed.

I attach 2 patches.

avoid_pin_scan_always.v1.patch 
Takes the approach that we generate the same WAL records as in 9.5, we just choose not to do anything with that information. This is possible because we don't care anymore whether it is toast or other relations. So it effectively reverts parts of the earlier patch.
This could be easily back-patched more easily.

toast_recheck.v1.patch
Adds recheck code for toast access. I'm not certain this is necessary, but here it is. No problems found with it.

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachment

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: psql completion for ids in multibyte string
Next
From: David Rowley
Date:
Subject: Re: Parallel Aggregate