Fujii Masao
masao****@gmail*****
2015年 8月 26日 (水) 11:06:44 JST
Hi, Attached patch implements the pg_gin_pending_cleanup function which cleans up the pending list of the specified GIN index by moving tuples in it to the main GIN data structure in bulk. Then this function returns the number of pages in the pending list cleaned up. I'd like to add this function into the master. Even without this function, we can clean up the pending list by using VACUUM. However, since VACUUM needs to do not only the pending list cleanup but also other various jobs, it usually takes a long time and its performance impact is likely to be big. So I think that pg_gin_pending_cleanup function is useful because we can clean up the list more quickly and avoid such big performance impact by using the function. Thought? Regards, -- Fujii Masao -------------- next part -------------- $B%F%-%9%H7A<00J30$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B... $B%U%!%$%kL>(B: pg_gin_pending_cleanup_v1.patch $B7?(B: text/x-patch $B%5%$%:(B: 11653 $B%P%$%H(B $B ＠ bL@(B: $BL5$7(BTélécharger
Fork