> -----Original Message-----
> From: Andrew Sullivan [mailto:ajs(at)crankycanuck(dot)ca]
> Sent: Friday, March 11, 2011 5:02 PM
> To: pgsql-general(at)postgresql(dot)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.
> Andrew Sullivan
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.
In response to
pgsql-general by date
|Next:||From: Alexander Pyhalov||Date: 2011-03-14 14:06:03|
|Subject: DBMS upgrade and backups|
|Previous:||From: Merlin Moncure||Date: 2011-03-14 13:25:03|
|Subject: Re: Values larger than 1/3 of a buffer page cannot be indexed.|