Re: WAL Log Size

On Thu, 28 Feb 2008, Greg Smith wrote:

> Nope; you'd want to play with XLOG_SEG_SIZE to change this.  Have to
> dump/initdb/reload your database as well to do it.  Really just not a good
> idea.

Thanks for the insight there. I figured changing the code would be
dangerous. I'm glad I asked, and thanks for the answer!

> create table xlog_switch as
> select '0123456789ABCDE' from generate_series(1,1000000);
> drop table xlog_switch;

Thanks for the 2-liner. Good stuff. I'll be putting that into place
ASAP!

--
John Evans
Administrator of kilnar.com