Re: pg_xlog Concern

[Mathew Moon <mathew.moon@xxxxxxxxxx>]

------------------

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