Re: How to reduce WAL file Size

I am dealing with backup of databases. Now eventhough there are not many
changes in the DB, it creates WAL file of 16 mb. Now because I am working on
a application which takes full & inc backup of db after specific
intervals..if for small changes it creates 16 mb files then storing them
will eat up lot many space. As I am not having DB knowledge I am just
assuming that it will create problems in terms of storage space. That is my
concern.

If you will explain this thing then it will help me in a good way :)

Thank you.

Alban Hertroys-3 wrote:
>
> 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!
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

--
View this message in context: http://www.nabble.com/How-to-reduce-WAL-file-Size-tp25799623p25816266.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.