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

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 (view raw or flat)
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

pgsql-general by date

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

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