------------------
> "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

Reply via email to