Re: How to reduce WAL file Size

> 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 ?


pg_switch_xlog() is the switch function.

The option
--with-wal-segsize=SEGSIZE
                          set WAL segment size in MB [16]
when you compile postgresql allow you to change the size of these files (but you
can't do it only restarting :S )



--
              Emanuel Calvo Franco
             DBA at:  www.siu.edu.ar
        www.emanuelcalvofranco.com.ar