| From: | Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)com> |
|---|---|
| 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 16:58:59 |
| Message-ID: | f205bb120910080958h5f7cff42v45a8863d61268346@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-10-08 17:38:52 | Re: Give me a HINT or I'll got crazy ;) |
| Previous Message | wstrzalka | 2009-10-08 16:11:18 | Give me a HINT or I'll got crazy ;) |