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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
