Re: WAL disk space

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Erin Munro <emunro(at)ll(dot)mit(dot)edu>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WAL disk space
Date: 2002-12-09 16:33:10
Message-ID: 20021209083146.H61169-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Mon, 9 Dec 2002, Erin Munro wrote:

> An empty database cluster takes up 20 MB, 16 of which
> are dedicated to a WAL file. This seems to be a lot
> for a small or low-traffic database. Is there any way
> to reduce the size of this WAL file, besides reverting
> to version 7.0 (where WAL isn't used)?

IIRC, you can change the segment size at compile time in
xlog.h.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-12-09 16:47:08 Re: WAL disk space
Previous Message Jean-Luc Lachance 2002-12-09 16:11:32 Re: Rules/Trigges Trade-offs