Re: pg_xlog Concern
| От | Sameer Thakur |
|---|---|
| Тема | Re: pg_xlog Concern |
| Дата | |
| Msg-id | 1432106218652-5850100.post@n5.nabble.com обсуждение |
| Ответ на | pg_xlog Concern (Sachin Srivastava <ssr.teleatlas@gmail.com>) |
| Ответы |
Re: pg_xlog Concern
|
| Список | 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.
В списке pgsql-general по дате отправления: