Indexes getting corrupted.
От | Bruno G. Albuquerque |
---|---|
Тема | Indexes getting corrupted. |
Дата | |
Msg-id | 42A73B60.7010909@dba.com.br обсуждение исходный текст |
Ответы |
Re: Indexes getting corrupted.
Re: Indexes getting corrupted. |
Список | pgsql-admin |
I am having a weird problem here. I have the automated process to install PostgreSQL (8.0.1) on Windows 2000 machines. Besides installing the database server itself, my process does the following: 1 - Runs initdb to created the database I will be using. 2 - Runs a SQL script that creates the entire database and populates some of the tables. 3 - Runs another script that populates other tables (using COPY). What happens is that, sometimes, after the entire process run, I end up with a database with virtually all indexes corrupt! Try to use the indexes for anything results in "index is not a btree" error. This happens randomly and I can get it fixed sometimes by simply erasin everything and starting over. It happened in more thna one machine, if that matters. Also, changing the database from one partition to another almost all the time solves it (all machines have 2 partitions). Any ideas about what can be causing this? Manually doing "reindex index" gets the indexes sorted. Is there a way to automatically reindex all indexes in one go? that would at least help me a bit. Thanks in advance. -Bruno ********************************************************************** Informação transmitida destina-se apenas à pessoa a quem foi endereçada e pode conter informação confidencial, legalmenteprotegida e para conhecimento exclusivo do destinatário. Se o leitor desta advertência não for o seu destinatário,fica ciente de que sua leitura, divulgação ou cópia é estritamente proibida. Caso a mensagem tenha sido recebidapor engano, favor comunicar ao remetente e apagar o texto de qualquer computador. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidentialand/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any actionin reliance upon this information, by person or entity other than the intended recipient is prohibited. If you receivedthis in error, please contact the sender and delete the material from any computer. **********************************************************************
В списке pgsql-admin по дате отправления: