Re: FW: getting error while running sql on mm_activealrm table - Mailing list pgsql-general

From John R Pierce
Subject Re: FW: getting error while running sql on mm_activealrm table
Date
Msg-id 547FFBC1.10400@hogranch.com
Whole thread Raw
In response to Re: FW: getting error while running sql on mm_activealrm table  (M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>)
List pgsql-general
On 12/3/2014 9:30 PM, M Tarkeshwar Rao wrote:
> I have found corrupted indexes are usually a sign that something is not well with the server. It is good to check and
makesure memory, CPU's and hard drives are all happy and not reporting problems. I have found overheating servers to be
particularlyprone to index corruption and if indexes can get corrupt one has to worry about data becoming corrupt too. 

do your servers not have ECC memory?   the number one source of data
corruption is cached data getting transient one-bit errors, which occur
at a more common rate than you might expect if you have many gigabytes
of ram...   ECC will fix and report these single bit errors.




--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: M Tarkeshwar Rao
Date:
Subject: Re: FW: getting error while running sql on mm_activealrm table
Next
From: Sameer Kumar
Date:
Subject: Re: High Availability Cluster