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