From: Fabio C. Bon <bon@kernel.net.uy>
To: pgsql-admin-owner@postgresql.org
Subject: Questions about fsync
Date: Fri, 29 Jul 2005 13:30:46 -0300
Message-ID: <025b01c5945a$dfc1ba70$0501a8c0@fabio> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bon@kernel.net.uy, pgsql-admin-owner@postgresql.org
Subject: Re: Questions about fsync
In-Reply-To: <025b01c5945a$dfc1ba70$0501a8c0@fabio>
References: <025b01c5945a$dfc1ba70$0501a8c0@fabio>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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