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 21:18:06
Message-ID: 1D3829A4-8125-42A5-BAAC-9BCFB7EC04FD@myemma.com (view raw or flat)
Thread:
Lists: pgsql-general
On Feb 28, 2008, at 1:58 PM, Alan Hodgson wrote:

> On Thursday 28 February 2008, Erik Jones <erik(at)myemma(dot)com> wrote:
>> Or, even simpler:
>>
>> SELECT pg_switch_xlog();
>
> The original poster is using 8.1.

Ah, I didn't realize that was only available in >= 8.2, thanks for  
the clarification.

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

pgsql-general by date

Next:From: Terry Lee TuckerDate: 2008-02-28 21:20:56
Subject: LIMIT Question
Previous:From: Kynn JonesDate: 2008-02-28 21:14:46
Subject: "Consider compacting this relation..." ???

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