Thank you. I usually remember to mention these things...
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
>
>
>
