Re: Need Help on wal_compression

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Rambabu V <ram(dot)wissen(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Need Help on wal_compression
Date: 2018-01-09 20:39:33
Message-ID: CAOR=d=38OuYhM+n2fm+GtWLk_qURxTPyZY8F5zFERf2KUvD_SQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jan 8, 2018 at 11:53 PM, Rambabu V <ram(dot)wissen(at)gmail(dot)com> 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
> us on this.

Compression won't change the number of wal files, it will just make
the ones created smaller.

--
To understand recursion, one must first understand recursion.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Kumar, Virendra 2018-01-09 21:18:02 Performance of a Query
Previous Message Claudio Freire 2018-01-09 19:45:19 Re: Batch insert heavily affecting query performance.