Re: Hardware Diagnostics Advice - Mailing list pgsql-admin

From Ogden Nefix
Subject Re: Hardware Diagnostics Advice
Date
Msg-id 3E6BDE83.7020101@waste.org
Whole thread Raw
In response to Hardware Diagnostics Advice  (Ogden Nefix <onefix@waste.org>)
List pgsql-admin
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
>
>
>


pgsql-admin by date:

Previous
From: Ogden Nefix
Date:
Subject: Table Sizes
Next
From: Jason Pyeron
Date:
Subject: Deal with this. Re: Majordomo results: unsubscribe