Re: checkpoints, proper config

Поиск
Список
Период
Сортировка
От Tory M Blue
Тема Re: checkpoints, proper config
Дата
Msg-id CAEaSS0Zq=-0mgvk6PjjxY7RbbitxyKKuuHBuA4fG=s66thbfCQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: checkpoints, proper config  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: checkpoints, proper config  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: checkpoints, proper config  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-performance


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 по дате отправления:

Предыдущее
От: "Sheena, Prabhjot"
Дата:
Сообщение: postgresql upgrade from 9.3 to 9.4 error
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: checkpoints, proper config