Problem with corrupt index
Diogo Biazus <diogo@ikono.com.br>
From: Diogo Biazus <diogo@ikono.com.br>
To: pgsql-general@postgresql.org
Date: 2002-09-30T17:41:16Z
Lists: pgsql-general
Hi everybody, I have a table that requires periodical updates (every 5 seconds) in more than one register. The table is very small (about 7 registers) and it wont grow. Sometimes the access to that table becomes very slow, and VACUUM dont fix it, I have to REINDEX the table. Anyone can tell me what should be the cause of this problem? Thanks in advance, -- Diogo de Oliveira Biazus diogo@ikono.com.br Ikono Sistemas e Automação http://www.ikono.com.br