Thread: Vacuum

Welcom.

I have that message every time when I do vacuum;

vacuum;
NOTICE:  Index tb_klienci_id_klienci_key: NUMBER OF INDEX' TUPLES (8776)
IS NOT
THE SAME AS HEAP' (8774)
NOTICE:  Index tb_klienci_id_klienci_key: NUMBER OF INDEX' TUPLES (8776)
IS NOT
THE SAME AS HEAP' (8774)
VACUUM

I dont know it is very bad message if that,
I have a problem could you help me.


Sorry for may english

Grzegorz Przeździecki  <grzegorz_przezdziecki@lupus.waw.pl> writes:
> vacuum;
> NOTICE:  Index tb_klienci_id_klienci_key: NUMBER OF INDEX' TUPLES (8776)
> IS NOT THE SAME AS HEAP' (8774)

There are some bugs here that we are looking into fixing for 7.0.
In the meantime, you should be able to get rid of the message by
dropping and recreating that index.
        regards, tom lane

> Grzegorz Przeździecki  <grzegorz_przezdziecki@lupus.waw.pl> writes:
> > vacuum;
> > NOTICE:  Index tb_klienci_id_klienci_key: NUMBER OF INDEX' TUPLES (8776)
> > IS NOT THE SAME AS HEAP' (8774)
> 
> There are some bugs here that we are looking into fixing for 7.0.
> In the meantime, you should be able to get rid of the message by
> dropping and recreating that index.
> 

Yes, and 7.0 message will suggest exactly that.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 

Thanks


Tom Lane wrote:
> 
> Grzegorz Przeździecki  <grzegorz_przezdziecki@lupus.waw.pl> writes:
> > vacuum;
> > NOTICE:  Index tb_klienci_id_klienci_key: NUMBER OF INDEX' TUPLES (8776)
> > IS NOT THE SAME AS HEAP' (8774)
> 
> There are some bugs here that we are looking into fixing for 7.0.
> In the meantime, you should be able to get rid of the message by
> dropping and recreating that index.
> 
>                         regards, tom lane
> 
> ************

-- 

/*****************************/
void main(void)
{       Co to zrobic();       zeby dobrze zrobic();       i sie nie narobic();       return(TRUE);
}
/*****************************/