| От | Tom Lane |
|---|---|
| Тема | WARNING: do not turn off full_page_writes in PG 8.1.* |
| Дата | |
| Msg-id | 26693.1144351374@sss.pgh.pa.us обсуждение |
| Список | pgsql-announce |
Recent analysis has shown that turning off full_page_writes is not safe under *any* circumstances, even if you have infrastructure such as a battery-backed disk cache that should prevent partial page writes. We have seen two recent reports of full_page_writes = off causing failure to restart after a database crash, even though no OS- or hardware-level problem occurred. Our plan is to disable the variable in 8.1.4 and future 8.1.* releases (forcing the system to act as though it's always ON), but not remove the variable as that would cause unexpected breakage to postgresql.conf files. We will look into whether it's practical to re-enable it for 8.2; at present it appears that doing so will require a chunk of additional code that would be imprudent to back-patch. If you are running on 8.1.0 - 8.1.3, however, you need to make sure that full_page_writes is ON. For technical details see this thread: http://archives.postgresql.org/pgsql-hackers/2006-03/msg01168.php regards, tom lane
В списке pgsql-announce по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера