Re: pg_xlog content

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: pg_xlog content
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C202D11113@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: pg_xlog content  (Siddharth Shah <siddharth.shah@elitecore.com>)
Ответы Re: pg_xlog content  (Siddharth Shah <siddharth.shah@elitecore.com>)
Список pgsql-general
Siddharth Shah wrote:
>     I am not using wall based replication ? I no not have frequent &
> long transaction , need of checkpoints
> Just want to get what data resides in pg_xlog that it takes 16MB without
> any transactions.

It contains the transaction log files.

The files are precreated with a size of 16MB and filled with log entries.
There will normally be several of those files around.

Since your main objective is to keep size small, you can change
the default of 16MB by setting XLOG_SEG_SIZE in src/include/pg_config_manual.h
to a smaller value.

Yours,
Laurenz Albe

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Fwd: Cannot open include file: 'nodes/nodes.h'
Следующее
От: Shane Ambler
Дата:
Сообщение: Re: Favorite Tom Lane quotes