Re: COPY FREEZE and PD_ALL_VISIBLE

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: COPY FREEZE and PD_ALL_VISIBLE
Date: 2015-12-24 03:24:45
Message-ID: CAMkU=1wby4i5Bz5DWeUr6G1ZFhNjx6vrZN3D1EOGz=LwqFB=Hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Dec 23, 2015 at 6:14 PM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com> wrote:
> On Wed, Nov 4, 2015 at 12:08 PM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>> On Tue, Nov 3, 2015 at 8:07 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>>>
>>> On 3 November 2015 at 15:23, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>>>>
>>>> On Fri, Oct 23, 2015 at 6:29 AM, Simon Riggs <simon(at)2ndquadrant(dot)com>
>>>> wrote:
>>>>>
>>>>> Easy enough to do it at the end of the COPY FREEZE in one step.
>>>>
>>>>
>>>> Here, we might want to consider that setting bit in visibility map
>>>> will generate WAL log whereas Copy Freeze otherwise skip WAL
>>>> when wal_level is less than archive. This can lead to extra disk
>>>> writes which can slow down Copy Freeze, but OTOH that might
>>>> be acceptable.
>>>
>>>
>>> I'm building the map as I go, in the latest version of this patch I'm
>>> working on.
>>>
>>
>> As, you are working on this patch, I have marked it as "Waiting on Author".
>
> There has not been an update for this patch in a while, switched to
> "returned with feedback" because of lack of author's input.

And I've added Simon as an author, as I don't plan on picking it up
again myself as long as he is working on his alternative.

Thanks,

Jeff

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2015-12-24 03:29:47 Re: PATCH: index-only scans with partial indexes
Previous Message Michael Paquier 2015-12-24 03:09:03 Re: Commit fest status for 2015-11