Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_xlog Concern - Mailing list pgsql-general

From Mathew Moon
Subject Re: pg_xlog Concern
Date
Msg-id 4891FA75-516B-4734-9508-9843E8B713F2@vipaar.com
Whole thread Raw
In response to Re: pg_xlog Concern  (Sameer Thakur <samthakur74@gmail.com>)
List pgsql-general
Tree view
------------------
"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@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

pgsql-general by date:

Previous
From: Mathew Moon
Date:
Subject: Re: Memory Utilization Issue
Next
From: Naveed Shaikh
Date:
Subject: Re: Memory Utilization Issue