[Pgbigm-hackers] Add bigm_similarity details to documentation

Zurück zum Archiv-Index

Amit Langote amitl****@gmail*****
2013年 11月 22日 (金) 13:34:26 JST


On Fri, Nov 22, 2013 at 12:51 PM, Fujii Masao <masao****@gmail*****> wrote:
> On Fri, Nov 22, 2013 at 9:28 AM, Amit Langote <amitl****@gmail*****> wrote:
>>
>>
>> On Friday, November 22, 2013, Fujii Masao wrote:
>>>
>>> On Thu, Nov 21, 2013 at 11:36 PM, Amit Langote <amitl****@gmail*****>
>>> wrote:
>>> >
>>> >
>>> > On Thursday, November 21, 2013, Fujii Masao wrote:
>>> >>
>>> >> On Thu, Nov 21, 2013 at 12:46 AM, Amit Langote
>>> >> <amitl****@gmail*****>
>>> >> wrote:
>>> >> >
>>> >> >
>>> >> > On Wednesday, November 20, 2013, Beena Emerson wrote:
>>> >> >>
>>> >> >> Hello,
>>> >> >>
>>> >> >> The attached patch adds detailed information about bigm_similarity
>>> >> >> function
>>> >> >>
>>> >> >
>>> >> > About the gin pending stats, is there any relation with FASTUPDATE
>>> >> > parameter
>>> >> > worth mentioning like it's being turned on or off?
>>> >>
>>> >> Sorry. I could not understand the point. Could you elaborate this?
>>> >
>>> >
>>> > If  FASTUPDATE is turned off would there be a pending list? I am under
>>> > an
>>> > impression that there wouldn't be any; is that so?
>>>
>>> Yes, GIN index created with FASTUPDATE disabled doesn't have a pending
>>> list.
>>> So, in this case, pg_gin_pending_stats' pages and tuples columns always
>>> return
>>> 0. This is the same behavior as pgstatginindex() function which is
>>> provided by
>>> pgstattuple contrib module.
>>>
>>
>> Ah, I see. If users would already be aware of such behavior then I guess
>> it's not necessary to stress FASTUPDATE in documentation.
>
> So, you're thinking that we should document something like the following?
>
> Note that pg_gin_pending_stats' pages and tuples columns return 0 if
> its argument
> is the GIN index built with FASTUPDATE option disabled because it doesn't have
> a pending list. Please see <link to the proper PostgreSQL document>
> for the details
> of FASTUPDATE option.
>
> I don't have any strong opinion about this. If you think this is
> important, could you
> implement the patch? I will commit that!
>

Though users of this function would be aware of this, I think we can
still add a small note just as a reminder.
Attached patch adds the above note to pg_bigm_en-1.1.html.


--
Amit
-------------- next part --------------
$B%F%-%9%H7A<00J30$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
$B%U%!%$%kL>(B: pg_gin_pending_list_FASTUPDATE_note.patch
$B7?(B:         application/octet-stream
$B%5%$%:(B:     946 $B%P%$%H(B
$B @ bL@(B:       $BL5$7(B
Download 



Pgbigm-hackers メーリングリストの案内
Zurück zum Archiv-Index