Problem with corrupt index

From: Diogo Biazus <diogo(at)ikono(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with corrupt index
Date: 2002-09-30 17:41:16
Message-ID: 3D988CBC.2070707@ikono.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)ikono(dot)com(dot)br
Ikono Sistemas e Automação
http://www.ikono.com.br

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carfield Yim 2002-09-30 17:46:09 Error after updating postgresql
Previous Message Richard Huxton 2002-09-30 17:38:14 Re: cursors