Re: [HACKERS] Bug? relpages, reltuples resets to zero

> Hi,
>
> there seems to be a problem with the relation statistics in
> pg_class. Could someone explain why this happens?
>
> doc=> vacuum;
> VACUUM
> doc=> select relname, relpages, reltuples from pg_class
> doc-> where relname = 'doc_wordref';
> relname |relpages|reltuples
> -----------+--------+---------
> doc_wordref| 1099| 136027
> (1 row)
>
> -- ******** That's right
>
> doc=> explain select distinct refpage from doc_wordref
> doc-> where refword ~ '^a';
> NOTICE: QUERY PLAN:
>

Attached is a patch to vacuum.c I would like you to try. I wonder if
dirty pages are somehow never getting written out because of vacuum's
use of transactions.

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