pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Questions about fsync 2+ messages / 1 participants [nested] [flat]
* Questions about fsync @ 2005-07-29 16:30 Fabio C. Bon <bon@kernel.net.uy> 0 siblings, 0 replies; 2+ messages in thread From: Fabio C. Bon @ 2005-07-29 16:30 UTC (permalink / raw) To: pgsql-admin-owner@postgresql.org In the context of PostgreSQL 7.4, running over Linux Suse 9.0, I have some doubts that wanted to evacuate: In which processes impacts the property fsync? Which can be the problem to use fsync in false? When use fsync = false, the effective recording of the data in disk is done for criteria of the operating system, ¿ Is exact? Considering fsync = false, checkpoint_timeout=300. It given a crash of the operating system, after normally db shutdown. At db startup, there was corruption of data and a pg_resetlog was done. It is possible to lose data changed previous to last checkpoint ? Thanks, Fabio ^ permalink raw reply [nested|flat] 2+ messages in thread
* Questions about fsync @ 2005-08-04 13:22 Fabio C. Bon <bon@kernel.net.uy> 0 siblings, 0 replies; 2+ messages in thread From: Fabio C. Bon @ 2005-08-04 13:22 UTC (permalink / raw) To: pgsql-admin In the context of PostgreSQL 7.4, running over Linux Suse 9.0, I have some doubts that wanted to evacuate: In which processes impacts the property fsync? Which can be the problem to use fsync in false? When use fsync = false, the effective recording of the data in disk is done for criteria of the operating system, ¿ Is exact? Considering fsync = false, checkpoint_timeout=300. It given a crash of the operating system, after normally db shutdown. At db startup, there was corruption of data and a pg_resetlog was done. It is possible to lose data changed previous to last checkpoint ? Thanks, Fabio ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-08-04 13:22 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-07-29 16:30 Questions about fsync Fabio C. Bon <bon@kernel.net.uy> 2005-08-04 13:22 Questions about fsync Fabio C. Bon <bon@kernel.net.uy>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox