Re: How to reduce WAL file Size

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: Mitesh51 <mit_bca1(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to reduce WAL file Size
Date: 2009-10-08 23:54:57
Message-ID: 5E96E136-1D05-4D3A-A186-EC2A64491865@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8 Oct 2009, at 9:35, Mitesh51 wrote:

> By setting postgres.conf params...log files are generated of 16 MB
> each. How
> can I reduce the size of this files? & can I force the log files to
> switch
> with any command as we do in mysql like flush log? where we force
> the new
> log creation ?

Why do you want to reduce the WAL file size? What problem are you
trying to solve?

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.

!DSPAM:737,4ace7bd211681560221775!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2009-10-09 00:23:59 Re: Best data type to use for sales tax percent
Previous Message Mike Christensen 2009-10-08 23:50:47 Re: Best data type to use for sales tax percent