Skip site navigation (1) Skip section navigation (2)

-F option

From: newsreader(at)mediaone(dot)net
To: pgsql-novice(at)postgresql(dot)org
Subject: -F option
Date: 2000-12-11 23:45:22
Message-ID: 20001211184522.A30349@dragon.universe (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
manual page states that 

       -F     Disable an automatic fsync()  call  after  each  transaction.   This  option
              improves  performance,  but an operating system crash while a transaction is
              in progress may cause the loss of the most recently  entered  data.  Without
              the  fsync()  call the data is buffered by the operating system, and written
              to disk sometime later.

What I would like to know is what 'sometime later' means.
Is it one hour? 30 seconds? 30 minutes?  24 hours?  I really don't
mind losing the last 3 minutes or so of data.  If we are talking about 10
hours or so then I will not use that switch.  I'm not looking
for an answer with milisecond accuracy; just an upper bound +- 5 minutes
will be ok.

My usage is frequent lookup of small pieces of information, ocassionally
insert of small pieces of information and even less frequent update of small pieces
of information.  I have 7.0.3 on linux 2.2.18 and accessing from Apache::DBI
mod_perl.  I have about three tables or so with the largest table being over 1000 rows
and growing. Is postgres an overkill for this size of data?



pgsql-novice by date

Next:From: Diego A. Puertas F.Date: 2000-12-11 23:59:48
Subject: Serial field problem with Access 97
Previous:From: newsreaderDate: 2000-12-11 22:06:17
Subject: Re: default password

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group