Re: pg_xlog Concern

------------------
> "MY each WAL file is 16 MB."
-------------------
Are you saying that you want WAL segments to be smaller? WAL file segments are always the same size, which can be set with --with-WAL-segsize at build time but not at runtime.

Regards
Mathew

Sent from my iPhone

> On May 20, 2015, at 2:16 AM, Sameer Thakur <samthakur74(at)gmail(dot)com> wrote:
>
> Hello,
>> First: When I have given checkpoint segments=200 (As per my knowledge WAL
> file should be generated >200*2+3=403 only) but why it’s generating too much
> file. MY each WAL file is 16 MB.
>
> The formula is
> (2 + checkpoint_completion_target) * checkpoint_segments + 1
> or
> checkpoint_segments + wal_keep_segments + 1 files
>
> So what is your checkpoint_completion_target and wal_keep_segments?
> regards
> Sameer
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/pg-xlog-Concern-tp5849713p5850100.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general