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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
