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(BTélécharger
Fork