Re: [PERFORM] reltuples value less than rows in the table.

2011-08-25 Thread Kevin Grittner
parul wrote: > I have a index in a table. The value of the reltuples value in the > pg_class table for this index is less than the number of rows in > the table where the index is present. > For eg. if i have 800 rows in the table , the reltuples in the > pg_class for the index show the value as

[PERFORM] reltuples value less than rows in the table.

2011-08-25 Thread parul
I have a index in a table. The value of the reltuples value in the pg_class table for this index is less than the number of rows in the table where the index is present. For eg. if i have 800 rows in the table , the reltuples in the pg_class for the index show the value as 769. What are the scenari