Re: pg_xlog Concern

Поиск
Список
Период
Сортировка
От Mathew Moon
Тема Re: pg_xlog Concern
Дата
Msg-id 4891FA75-516B-4734-9508-9843E8B713F2@vipaar.com
обсуждение исходный текст
Ответ на Re: pg_xlog Concern  (Sameer Thakur <samthakur74@gmail.com>)
Список pgsql-general
Дерево обсуждения
------------------
"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 по дате отправления: