Re: WAL reducing size

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: sql2pg <sekhar(dot)career(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: WAL reducing size
Date: 2017-12-04 18:37:11
Message-ID: CAKFQuwaW+fem8QkBH0yA8wF7=oaY+in1cdkceoogOBvSPrU3Hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Dec 4, 2017 at 8:50 AM, sql2pg <sekhar(dot)career(at)gmail(dot)com> wrote:

> Is Postgres removes the committed transaction after archive. LIke in SQL
> Server , which removes the committed transactions after taking Log backup.
>

If I understand correctly, yes - eventually. The docs explain the behavior
and the configuration variables that control it.

https://www.postgresql.org/docs/10/static/wal-configuration.html

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Pacheco 2017-12-04 20:19:00 Re: [GENERAL] postmaster deadlock while logging after syslogger exited
Previous Message Day, David 2017-12-04 18:15:14 RE: attempting to retrieve column names from information schema fails.