Hello,
We have a combination of 9.3 and 9.4 databases used for logging of data.
We do not need a strong durability guarantee, meaning it is ok if on crash a minute or two of data is lost from our logs. (This is just stats for our internal tool).
I am looking at this page:
And it's not clear which setting I should turn on.
What we do NOT want is to lose the entire table or corrupt the database. We do want to gain speed though by not making DATA writes durable.
Which setting is appropriate for this use case?
At a glance it looks like a combination of
1) "Turn off synchronous_commit"
and possibly:
2) Increase checkpoint_segments and checkpoint_timeout ; this reduces the frequency of checkpoints, but increases the storage requirements of /pg_xlog.
3) Turn off full_page_writes; there is no need to guard against partial page writes.
The point here is to never get a corrupt database, but in case of crash we might lose a few minutes of last transactions.
Any suggestions please?
thank you,
-Alfred