Re: pg_xlog Concern

From: Sameer Thakur <samthakur74(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_xlog Concern
Date: 2015-05-20 07:16:58
Message-ID: 1432106218652-5850100.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sachin Srivastava 2015-05-20 07:25:00 Memory Utilization Issue
Previous Message Musall Maik 2015-05-20 06:52:33 Slaves show different results for query