On Thu, 28 Feb 2008, Greg Smith wrote:

Nope; you'd want to play with XLOG_SEG_SIZE to change this. Have to dump/initdb/reload your database as well to do it. Really just not a good idea.

Thanks for the insight there. I figured changing the code would be
dangerous. I'm glad I asked, and thanks for the answer!

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

Thanks for the 2-liner. Good stuff. I'll be putting that into place
ASAP!

--
John Evans
Administrator of kilnar.com

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to