Re: Notice in logg file

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Notice in logg file
Дата
Msg-id 200006130013.UAA11952@candle.pha.pa.us
обсуждение исходный текст
Ответы Re: Notice in logg file  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom, we fixed this, right?

> grzegorz.przezdziecki@crn.pl writes:
> > PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3
> 
> > 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.  It's not real critical --- the cross-check between index and
> table tuple count is just not bright enough to consider the possibility
> of "zombie" tuples (killed, but not dead yet because there are other
> transactions that can still see them).  I'd like to improve the cross-
> check so it doesn't emit bogus notices, but haven't figured out how yet.
> 
> If you see it even when the VACUUM is the only transaction running,
> then you might be well advised to drop and re-create the index.
> 
>             regards, tom lane
> 


--  Bruce Momjian                        |  http://www.op.net/~candle pgman@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
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "valter m"
Дата:
Сообщение: how an app can know when a table is altered ?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Proposal for fixing intra-query memory leaks