RE: Notice in logg file

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]

"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:

Apr 28 03:06:05 ziutek logger: NOTICE: Index
tb_klienci_id_klienci_key: NUMBER OF INDEX' TUPLES (10652)
IS NOT THE SAME AS HEAP' (10634)

This can happen if there are other transactions open while the VACUUM
runs.

Really ?
If I remember correctly,your sample cases have CREATE INDEX
and NUMBER OF INDEX TUPLES was not greater than HEAP.

Hmm, good point --- maybe this is something different.

As to this INDEX TUPLES > HEAP phenomenon in VACUUM.

The delay of WriteBuffer(cur_buffer) in vc_repair_frag() of
VACUUM may be one of the cause. cur_buffer is a buffer page
where new MOVED_IN tuples are inserted. It is dirtied when
another cur_buffer page is needed or tuple moving was finished.
OTOH newly inserted index tuples are dirtied immediately.
If VACUUM crashes before the cur_buffer is dirtied,the buffer
may be discarded without writing to disk. This may result that
some index tuples would point to UNUSED blocks.
Though it isn't a problem at the moment,updation of tuples
of the page would replace UNUSED blocks.

I'm not sure my guess is right or not.

Comments ?

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp