
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

Thu, 25 Nov 1999 09:26:50 +0100
Grzegorz =?iso-8859-2?Q?Prze=BCdziecki?=
	<grzegorz_przezdziecki@lupus.waw.pl>
Vacuum
Grzegorz =?iso-8859-2?Q?Prze=BCdziecki?=  <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

Thu, 25 Nov 1999 10:17:16 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Vacuum 
> Grzegorz =?iso-8859-2?Q?Prze=BCdziecki?=  <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, Pennsylvania 19026

Thu, 25 Nov 1999 13:36:09 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] Vacuum

Thanks


Tom Lane wrote:
> 
> Grzegorz =?iso-8859-2?Q?Prze=BCdziecki?=  <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);
}
/*****************************/

Fri, 26 Nov 1999 15:30:03 +0100
Grzegorz =?iso-8859-2?Q?Prze=BCdziecki?=
	<grzegorz_przezdziecki@lupus.waw.pl>
Re: [HACKERS] Vacuum