| From: | Amir Becher <abecher(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Corrupt index |
| Date: | 2003-04-10 16:22:05 |
| Message-ID: | 20030410162205.24984.qmail@web13901.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2003-04-10 16:25:45 | Re: pg_dump / pg_dumpall / memory issues |
| Previous Message | Murthy Kambhampaty | 2003-04-10 14:46:29 | Re: pg_dump / pg_dumpall / memory issues |