Re: pg_xlog content

Albe Laurenz wrote:
> 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
>
>
>
Thanks for info, will help me.
Yes, Objective is to reduce the size, Does setting XLOG_SEG_SIZE to
lower size make any difference in performance.
Is there any content other than log that that postgres refers from pg_xlog

regards,
Siddharth