Postgres Pro
Downloads
Home   >   mailing lists

Re: checkpoints, proper config - Mailing list pgsql-performance

From Tory M Blue
Subject Re: checkpoints, proper config
Date
Msg-id CAEaSS0Zq=-0mgvk6PjjxY7RbbitxyKKuuHBuA4fG=s66thbfCQ@mail.gmail.com
Whole thread Raw
In response to Re: checkpoints, proper config  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: checkpoints, proper config
Re: checkpoints, proper config
List pgsql-performance
Tree view


On Thu, Dec 10, 2015 at 12:00 PM, Joshua D. Drake <jd@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

pgsql-performance by date:

Previous
From: "Sheena, Prabhjot"
Date:
Subject: postgresql upgrade from 9.3 to 9.4 error
Next
From: "Joshua D. Drake"
Date:
Subject: Re: checkpoints, proper config