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 make sure memory, CPU's and hard drives are all happy and not reporting problems. I have found overheating servers to be particularly prone 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
