got it i think i need to sleep
i forgot each segment is 16 Mb... sorry for buggung u all
himanshuTom Lane <[EMAIL PROTECTED]> wrote:
Himanshu Baweja <[EMAIL PROTECTED]>writes:> i am trying to optimise postgres 8 running on a system is there any way to know how wht should be the valu
i think there is a bug in the checkpoint warning system.
i had set =>
checkpoint_timeout = 2000
checkpoint_warning = 2100
checkpoint_segments = 256 (for 1st run) and 64 (for 2nd run)
now i ran my test application my Wal-logs in PGDATA/pg_xlog increased by around 1.9 GB while in my log
Himanshu Baweja <[EMAIL PROTECTED]> writes:
> i am trying to optimise postgres 8 running on a system is there any way
> to know how wht should be the value of checkpoint_segments...
Enough so you usually aren't checkpointing more often than is specified
by checkpoint_timeout. If you do not k
i am trying to optimise postgres 8 running on a system is there any way to know how wht should be the value of checkpoint_segments...
i always keep fync = false since my server is fully reliable
increasing checkpoint_segments degrade the performace while checkpointing as it will have a
