Re: WAL Log Size

From: John Evans <admin(at)kilnar(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL Log Size
Date: 2008-02-28 23:24:42
Message-ID: Pine.LNX.4.64.0802281623160.9574@.
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-02-28 23:32:52 Re: LIMIT Question
Previous Message Dan Armbrust 2008-02-28 23:13:56 errors in pg_restore on windows?