Re: Is it possible to change the wal file size?

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Is it possible to change the wal file size?
Date: 2003-06-27 08:13:40
Message-ID: 3EFC4A0C.18400.3349B3@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 27 Jun 2003 at 10:12, u15074 wrote:

> Can I change the size of a wal file, and if so where can I change this? I'd like
> to set the value to bigger value than 16MB.

You can not change the size but you can increase the number of WAL files used.
See postgresql.conf.

Setting it too high does not achieve anything though. You need to have enough
disk bandwidth to make use of 200MB WAL logs.

Bye
Shridhar

--
Horngren's Observation: Among economists, the real world is often a special
case.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-06-27 08:18:36 Re: Large Object table data file does not have expected size
Previous Message u15074 2003-06-27 08:12:02 Is it possible to change the wal file size?