Re: How do you change the size of the WAL files?

> -----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.
>
> A
>
> --
> Andrew Sullivan
> ajs(at)crankycanuck(dot)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