Re: GIN pending list clean up exposure to SQL

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com>, Jaime Casanova <jaime(dot)casanova(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GIN pending list clean up exposure to SQL
Date: 2016-02-08 03:22:38
Message-ID: CAHGQGwE2n6r+uUcuFSptyZ7Ts4k3-7F-cctAaEE4rXNWbPgAHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Feb 8, 2016 at 9:53 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> On Wed, Jan 27, 2016 at 12:54 PM, Julien Rouhaud
> <julien(dot)rouhaud(at)dalibo(dot)com> wrote:
>> On 27/01/2016 10:27, Fujii Masao wrote:
>>>
>>> Thanks for updating the patch! It looks good to me.
>>>
>>> Based on your patch, I just improved the doc. For example, I added
>>> the following note into the doc.
>>>
>>> + These functions cannot be executed during recovery. + Use
>>> of these functions is restricted to superusers and the owner +
>>> of the given index.
>>>
>>> If there is no problem, I'm thinking to commit this version.
>>>
>>
>> Just a detail:
>>
>> + Note that the cleanup does not happen and the return value is 0
>> + if the argument is the GIN index built with <literal>fastupdate</>
>> + option disabled because it doesn't have a pending list.
>>
>> It should be "if the argument is *a* GIN index"
>>
>> I find this sentence a little confusing, maybe rephrase like this would
>> be better:
>>
>> - Note that the cleanup does not happen and the return value is 0
>> - if the argument is the GIN index built with <literal>fastupdate</>
>> - option disabled because it doesn't have a pending list.
>> + Note that if the argument is a GIN index built with
>> <literal>fastupdate</>
>> + option disabled, the cleanup does not happen and the return value
>> is 0
>> + because the index doesn't have a pending list.
>>
>> Otherwise, I don't see any problem on this version.
>
> This is a corner case that probably does not need to be in the docs,
> but I wanted to clarify it here in case you disagree: If the index
> ever had fastupdate turned on, when it is turned off the index will
> keep whatever pending_list it had until something cleans it up one
> last time.

I agree to add that note to the doc. Or we should remove the above
description that I added?

Regards,

--
Fujii Masao

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jinhua Luo 2016-02-08 04:51:17 Re: Does plpython support threading?
Previous Message Peter Geoghegan 2016-02-08 02:57:00 Re: Using quicksort for every external sort run