Re: Need Help on wal_compression

2018-01-09 Thread Michael Paquier
On Tue, Jan 09, 2018 at 01:53:14PM -0300, Claudio Freire wrote: > That shows 50% of that are full page writes. This is with compression > enabled. WAL compression will only help FPW, so if you don't have a large > volume of FPW, or they don't compress well, you won't benefit much. This highly depe

Re: Need Help on wal_compression

2018-01-09 Thread Jeff Janes
On Tue, Jan 9, 2018 at 1:53 AM, Rambabu V wrote: > Hi Team, > > Daily 4000 Archive files are generating and these are occupying more > space, we are trying to compress wall files with using wal_compression > parameter, but we are not seeing any change in wal files count, could you > please help u

Re: Need Help on wal_compression

2018-01-09 Thread Scott Marlowe
On Mon, Jan 8, 2018 at 11:53 PM, Rambabu V wrote: > Hi Team, > > Daily 4000 Archive files are generating and these are occupying more space, > we are trying to compress wall files with using wal_compression parameter, > but we are not seeing any change in wal files count, could you please help > u

Re: Need Help on wal_compression

2018-01-09 Thread Claudio Freire
On Tue, Jan 9, 2018 at 3:53 AM, Rambabu V wrote: > Hi Team, > > Daily 4000 Archive files are generating and these are occupying more > space, we are trying to compress wall files with using wal_compression > parameter, but we are not seeing any change in wal files count, could you > please help u

Need Help on wal_compression

2018-01-09 Thread Rambabu V
Hi Team, Daily 4000 Archive files are generating and these are occupying more space, we are trying to compress wall files with using wal_compression parameter, but we are not seeing any change in wal files count, could you please help us on this.