Fwd: --with-wal-segsize in-effective?

[Dhimant Patel <drp4kri@xxxxxxxxx>]

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 <drp4kri@xxxxxxxxx>
Date: Wed, Mar 3, 2010 at 12:32 PM
Subject: --with-wal-segsize in-effective?
To: pgsql-admin@xxxxxxxxxxxxxx


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.