| From: | "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: page 1 of relation global/11787 was uninitialized |
| Date: | 2013-04-09 17:27:59 |
| Message-ID: | 20130409172759.GC12023@cuci.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Joshua D. Drake wrote:
>full_page_writes = off is the problem.
>Turning this parameter off speeds normal operation, but might lead to
>either unrecoverable data corruption, or silent data corruption,
>after a system failure. The risks are similar to turning off fsync,
>though smaller, and it should be turned off only based on the same
>circumstances recommended for that parameter.
Well, silent data corruption would have been "ok" (to a certain extent).
Unrecoverable data corruption would be ok too, if it would only imply
losing some of the more recent parts of the data (at least for this database).
--
Stephen.
"Reality is merely an illusion,
albeit a very persistent one." -- Albert Einstein
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-04-09 17:28:26 | Re: MV patch broke users of ExplainOneQuery_hook |
| Previous Message | Stephen R. van den Berg | 2013-04-09 17:18:57 | Re: page 1 of relation global/11787 was uninitialized |