Re: WAL reducing size

2017-12-04 Thread Michael Paquier
On Tue, Dec 5, 2017 at 6:12 AM, Alvaro Herrera wrote: > sql2pg wrote: >> how about uncommitted(open transactions) . if a segment has 1 committed and >> 2 uncommitted transactions then will it keep the segment instead deleting it >> after checkpoint , since it has 2 uncommitted transactions > > Th

Re: WAL reducing size

2017-12-04 Thread Alvaro Herrera
sql2pg wrote: > how about uncommitted(open transactions) . if a segment has 1 committed and > 2 uncommitted transactions then will it keep the segment instead deleting it > after checkpoint , since it has 2 uncommitted transactions There is no connection between transaction commit and checkpoint

Re: WAL reducing size

2017-12-04 Thread sql2pg
how about uncommitted(open transactions) . if a segment has 1 committed and 2 uncommitted transactions then will it keep the segment instead deleting it after checkpoint , since it has 2 uncommitted transactions -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: WAL reducing size

2017-12-04 Thread David G. Johnston
On Mon, Dec 4, 2017 at 8:50 AM, sql2pg 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 configurati

WAL reducing size

2017-12-04 Thread sql2pg
Is Postgres removes the committed transaction after archive. LIke in SQL Server , which removes the committed transactions after taking Log backup. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html