> -----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

In response to

• Re: How do you change the size of the WAL files? at 2011-03-11 22:02:17 from Andrew Sullivan

Responses

• Re: How do you change the size of the WAL files? at 2012-01-09 18:45:40 from rama

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.