Skip site navigation (1) Skip section navigation (2)

Re: WAL Log Size

From: Erik Jones <erik(at)myemma(dot)com>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL Log Size
Date: 2008-02-28 19:29:04
Message-ID: 965CB986-7659-49B6-BA5F-6C0AB67A9C3F@myemma.com (view raw or flat)
Thread:
Lists: pgsql-general
On Feb 28, 2008, at 12:51 PM, Alan Hodgson wrote:

> On Thursday 28 February 2008, John Evans <admin(at)kilnar(dot)com> wrote:
>>    I've heard that upgrading to 8.2 or 8.3 will allow me to setup a
>> timeout value for WAL log creation, but upgrading at this time is  
>> not an
>> option for various reasons.
>>
>>    Any insight that you can provide will be greatly appreciated!
>
> Write a script that does "something" that results in 16MB of WAL  
> logging and
> run it whenever you want a rotation to occur. Inserting a few hundred
> thousand rows into an otherwise empty table should work. If it's not
> indexed it won't impact your server much, especially if your normal
> transaction volume is that low.

Or, even simpler:

SELECT pg_switch_xlog();

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com




In response to

Responses

pgsql-general by date

Next:From: Jeff DavisDate: 2008-02-28 19:48:10
Subject: Re: "=" or ":=" ?
Previous:From: BERTRAND JoëlDate: 2008-02-28 19:11:45
Subject: Re: "=" or ":=" ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group