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
