Re: How do you change the size of the WAL files?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rama <rsomaraju(at)masergy(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How do you change the size of the WAL files?
Date: 2012-01-09 23:58:16
Message-ID: 6603.1326153496@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

rama <rsomaraju(at)masergy(dot)com> writes:
> Due to the small file size I see thousands of files being generated and it
> takes for ever to list thousands of files from archive directory which
> stores 2 days worth of files. Sizing of WAL logs should be left to the
> choice of people using the software. Limiting to a very small random 16MB
> size isn't a good design.

There are tradeoffs in the other direction too, but if you feel you must
have a different value, see configure's --with-wal-segsize option. Note
that you cannot change this without re-initdb.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-01-10 00:17:33 Re: queries timeout during backup postgres database
Previous Message Ondrej Ivanič 2012-01-09 23:57:07 Re: Time to move table to new tablespace