Re: WAL segments size

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL segments size
Date: 2007-11-12 19:42:31
Message-ID: 20071112194231.GZ32349@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 12, 2007 at 05:14:24PM -0300, Bruno Almeida do Lago wrote:
> I was looking for a parameter on postgresql.conf to increase the WAL
> segments size, but according to documentation this can only be changed while
> building PostgreSQL.

You mean this:

http://www.postgresql.org/docs/8.2/static/runtime-config-wal.html#GUC-CHECKPOINT-SEGMENTS

?

That doesn't say you have to set it at compile time. You can't change it
without _restarting_ Postgres. That's because it's something that has to be
initialized at start up.

A

--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-11-12 19:52:43 Re: WAL segments size
Previous Message hubert depesz lubaczewski 2007-11-12 19:41:20 Re: Regression in 8.3?