Corrupt index
От | Amir Becher |
---|---|
Тема | Corrupt index |
Дата | |
Msg-id | 20030410162205.24984.qmail@web13901.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: Corrupt index
|
Список | pgsql-general |
I am experiencing frequent index corruptions (almost daily). The tables have about a million records. I solve the problem by using the REINDEX TABLE command and rerunning my programs. Does anyone know why I might be experiencing these problems? I am using batch mode to insert a few thousand records at a time in order to improve performance - could the index corruption be caused by a bug in the batch mode? Also, is there a way to determine whether an index is corrupt (other than seeing inconsistencies in the data)? I am running PostgreSQL 7.3.1 on Red Hat 8.0. I access and modify the database through Java (using the JDBC driver). __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com
В списке pgsql-general по дате отправления: