pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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