> -----Original Message----- > From: Andrew Sullivan [mailto:a...@crankycanuck.ca] > Sent: Friday, March 11, 2011 5:02 PM > To: pgsql-general@postgresql.org > Subject: Re: How do you change the size of the WAL files? > > On Fri, Mar 11, 2011 at 12:58:30PM -0500, runner wrote: > > My boss is used to using Oracle where you can set the size > of the files. > > So your boss wants this because a system with a completely > different architecture works that way? Heck, I'd like the > Nokia phone I bought recently as an experiment to work > anything like as well as my three year old iphone, too, but > that's not the way of the world. > > I suspect that your boss wants this because of a preconceived > notion of what the WAL is doing, and worries about what it > would do if it worked the same way as Oracle. In particular, > you might want to ask your boss if his worry is running out > of rollback segments. We don't have that problem. (We have > other ones, and one of them will be made worse if you make > these files bigger.) > > I'll bet a pretty good lunch this isn't what you want, > although it's still barely possible that it is. > > A > > -- > Andrew Sullivan > a...@crankycanuck.ca >
A bit out of topic, but a small correction here: Oracle's analog of WAL files is RedoLog files, and they rollback segments (or newer UNDO tablespace) is separate from RedoLog files. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
