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

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