Re: WAL Log Size - Mailing list pgsql-general

From John Evans
Subject Re: WAL Log Size
Date
Msg-id Pine.LNX.4.64.0802281623160.9574@.
Whole thread Raw
In response to Re: WAL Log Size  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Dan Armbrust"
Date:
Subject: errors in pg_restore on windows?
Next
From: "Scott Marlowe"
Date:
Subject: Re: LIMIT Question