To investigate this further I worked on the 8.4.2 source code and it allows to set the xlog segment size but still does not follow what documentation implies - unless I am wrong.
--with-wal-segsize=2 as per documentation should give me 4MB size segment, I am getting it of 2MB. Thanks, DP. ---------- Forwarded message ---------- From: Dhimant Patel <drp4...@gmail.com> Date: Wed, Mar 3, 2010 at 12:32 PM Subject: --with-wal-segsize in-effective? To: pgsql-admin@postgresql.org Hi All, I am working with latest source downloaded from postgres org site. I compiled and installed the source with --with-wal-segsize=2, assuming it should give me 4MB size xlog files. (As per the documentation it is a power of 2 value.) During the compilation the configure script spitted out "checking for WAL segment size... 2MB" - so something was off - and I could not imagine what it is. After successful install and creating database, I still got 16MB files in my pg_xlog directory. That's too bad. I can not seem to be able to follow. I thought it time to turn on archive anyway. I got 16MB files in my archive location! So what am I doing wrong? Please help. -DP.
