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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
