Re: [GENERAL] How to reduce WAL file Size

2009-10-09 Thread Alvaro Herrera
Alban Hertroys wrote: > On 9 Oct 2009, at 8:48, Mitesh51 wrote: > >Alban Hertroys-3 wrote: > > What's this? Did my name change suddenly? Or is yahoo-mail a bad > mail client? Mystifying eh? It's nabble.com's way of identifying unique posters. You have probably posted from other three different

Re: [GENERAL] How to reduce WAL file Size

2009-10-09 Thread Sam Mason
On Thu, Oct 08, 2009 at 11:48:29PM -0700, Mitesh51 wrote: > 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

Re: [GENERAL] How to reduce WAL file Size

2009-10-09 Thread Alban Hertroys
On 9 Oct 2009, at 8:48, Mitesh51 wrote: 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 cr

Re: [GENERAL] How to reduce WAL file Size

2009-10-08 Thread Mitesh51
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 u

Re: [GENERAL] How to reduce WAL file Size

2009-10-08 Thread Alban Hertroys
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

Re: [GENERAL] How to reduce WAL file Size

2009-10-08 Thread Emanuel Calvo Franco
> 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 op

[GENERAL] How to reduce WAL file Size

2009-10-08 Thread Mitesh51
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 ? -- View this message in context: http://www.nabble.com/