Re: WAL Log Size

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL Log Size
Date: 2008-02-29 00:00:20
Message-ID: 20080229000020.GJ1653@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 28, 2008 at 04:35:44PM -0500, Greg Smith wrote:
> Courtesy of Simon (
> http://archives.postgresql.org/pgsql-general/2007-06/msg00015.php ) you
> can force 16MB worth of WAL activity that doesn't leave any changes behind
> with:
>
> create table xlog_switch as
> select '0123456789ABCDE' from generate_series(1,1000000);
> drop table xlog_switch;

Just out of interest, why doesn't it do the following?

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

Thanks,
Sam

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Rupp 2008-02-29 03:17:17 rule question
Previous Message Scott Marlowe 2008-02-28 23:34:40 Re: "Consider compacting this relation..." ???