It's Postgres 7.2.4 with Red Hat Linux 7.3....
It seems that out of nowhere, on almost every other vacuum, we need to reindex certain indexes. The vacuum seems to freeze on certain ones. Upon re-indexing, the vacuum then runs fine, until it comes to another index. So, we are manually indexing every index that the vacuum complains about.
Why would this occur?
Thank you
Ogden
Justin Clift wrote:
Hi Ogden,
It's probably a good idea to mention the version of PostgreSQL and the version of Linux that you're using, as _if_ it's a bug in either, people may already be aware of it.
:)
Regards and best wishes,
Justin Clift
Ogden Nefix wrote:
Hi,
We have run into issues where indexes are being corrupted on our large database (about 9Gb).
The hardware setup is a RAID Array and we just want to confirm all the hard drives have the correct throughput.
Are there any good Linux hardware diagnostic tools out there that have worked for others on this list?
Thank you
Ogden
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
