Hello,

I have large table obout 1 milion rows - 80 GB.

table_AAAA

Column name Type Nulls

id_name char(10) no
seria_name char(10) no
value integer no

For this table i have index:

create unique index i_table_AAAA on table_AAAA (id_name,seria_name) using btree


Table table_AAAA is not increased. But index i_table_AAAA after four-five days increased about 1 GB.

It is normal situation ??
How i can monitoring this index ??

Hi,

Monitoring a table and its indexes can be done with:An what happens with the index after issuing astatement?

Regards

force execute a b-tree check with onmode
i don't remember if this command works in 9.4 ...