> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general