Re: [HACKERS] GUC for cleanup indexes threshold.

On Wed, Feb 15, 2017 at 4:39 PM, Ideriha, Takeshi
<ideriha.takeshi@jp.fujitsu.com> wrote:
> Hi, I tried regression test and found some errors concerning brin and gin,
> though I didn't look into this.
>
> Here's a log:
>
> *** /home/ideriha/postgres-master/src/test/regress/expected/brin.out    2017-02-13 11:33:43.270942937 +0900
> --- /home/ideriha/postgres-master/src/test/regress/results/brin.out     2017-02-15 14:58:24.725984474 +0900
> ***************
> *** 403,408 ****
>   SELECT brin_summarize_new_values('brinidx'); -- ok, no change expected
>    brin_summarize_new_values
>   ---------------------------
> !                          0
>   (1 row)
>
> --- 403,408 ----
>   SELECT brin_summarize_new_values('brinidx'); -- ok, no change expected
>    brin_summarize_new_values
>   ---------------------------
> !                          5
>   (1 row)
>
>
> ======================================================================
>
> *** /home/ideriha/postgres-master/src/test/regress/expected/gin.out     2016-12-20 16:49:09.513050050 +0900
> --- /home/ideriha/postgres-master/src/test/regress/results/gin.out      2017-02-15 14:58:25.536984461 +0900
> ***************
> *** 20,26 ****
>   select gin_clean_pending_list('gin_test_idx'); -- nothing to flush
>    gin_clean_pending_list
>   ------------------------
> !                       0
>   (1 row)
>
>   -- Test vacuuming
> --- 20,26 ----
>   select gin_clean_pending_list('gin_test_idx'); -- nothing to flush
>    gin_clean_pending_list
>   ------------------------
> !                       8
>   (1 row)
>
>   -- Test vacuuming
>
> ======================================================================
>
>

Thank you for testing!

It's a bug. Attached latest version patch, which passed make check.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers