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

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

[PERFORM] Re: How to track number of connections and hosts to Postgres cluster

lately i did sth similar in one of our servers, to keep track of active, idle and idle in transaction connections so as to make some optimization in the connection pooling and i didn't notice any serious io activity there (had the cron job run every minute). so imho unless the server is seriously i

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

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