On Thu, Dec 10, 2015 at 12:00 PM, Joshua D. Drake <j...@commandprompt.com> wrote:
> On 12/10/2015 10:35 AM, Tory M Blue wrote: > > >> Thiis valid regardless of the workload? >> > > Yes. > > > Seems that I would be storing a >> ton of data and writing it once an hour, so would have potential perf >> hits on the hour. I guess I'm not too up to date on the checkpoint >> configuration. >> > > No, that isn't how it works. > > http://www.postgresql.org/docs/9.4/static/wal-configuration.html > > Thanks will give this a read and get my self up to snuff.. > >> My settings on this particular DB >> >> fsync = off >> > > This will cause data corruption in the event of improper shutdown. > > >> #synchronous_commit = on >> >> > I would turn that off and turn fsync back on. > > synchronous is commented out, is it on by default? This is a slony slave node, so I'm not too worried about this particular host losing it's data, thus fsync is off, thanks again sir Tory
