Re: FW: getting error while running sql on mm_activealrm table

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: FW: getting error while running sql on mm_activealrm table
Дата
Msg-id 547FFBC1.10400@hogranch.com
обсуждение исходный текст
Ответ на Re: FW: getting error while running sql on mm_activealrm table  (M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>)
Список 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 по дате отправления:

Предыдущее
От: M Tarkeshwar Rao
Дата:
Сообщение: Re: FW: getting error while running sql on mm_activealrm table
Следующее
От: Sameer Kumar
Дата:
Сообщение: Re: High Availability Cluster