------------------ > "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 <samthaku...@gmail.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
