Skip site navigation (1) Skip section navigation (2)

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

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How do you change the size of the WAL files?
Date: 2011-03-11 22:02:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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

In response to


pgsql-general by date

Next:From: hubert depesz lubaczewskiDate: 2011-03-11 23:04:30
Subject: Re: Huge spikes in number of connections doing "PARSE"
Previous:From: Andrew SullivanDate: 2011-03-11 21:58:08
Subject: Re: How do you change the size of the WAL files?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group